Simple search based on MySQL

For each item I have two fields (these values): name (for example, iPhone) and manufacturer (for example, Apple) - and I want to implement search by these fields.

Should I use MySQL built-in search mechanisms or something like Sphinx? Any recommendations are appreciate开发者_开发百科d.

It really depends on your table size. I would start using pure MySQL queries and indexing tables where applicable. Once your queries take too much time, even with indexed tables, I would consider search servers like Sphinx.