I have a gaming website. I want to make a search engine where users can search my database for games. There are two fields I need to search. A field called Name and one called Object. The name is pretty short, and Object is a brief description of the game. I have seen search engines that just search fields using something like SELECT * FROM Table WHERE Name LIKE '%$query%' OR Object LIKE '%$query%' and I have seen ones where keywords are put into a database and those keywords are searched. Because my site is game related, I figured people would be entering a few words, like tetris or baseball, and not long phrases like you would do in google. Which method do you think would be the best?
