I am running a simple mysql full-text query that searches for users on my site based off of their "display name". The query example is below - in this example we are searching 'lancaster toy store': SELECT MATCH(`display_name`) AGAINST ('lancaster toy store') as `rel` WHERE MATCH(`display_name`) AGAINST ('lancaster toy store') ORDER BY ...
In my this query: SELECT *, MATCH(keywords) AGAINST ('get back future 2 ' IN BOOLEAN MODE ) AS score FROM movie WHERE MATCH (keywords) AGAINST ('get back future 2 +movie' IN BOOLEAN MODE) HAVING score > 0 ORDER BY score DESC, in_cinema DESC when the record match the all keywords:' get back future 2',it return the right record.But wi...
Knowing full well that my InnoDB tables don't support FULLTEXT searches, I'm wondering what my alternatives are for searching text in tables ? Is the performance that bad when using LIKE ? I see a lot of suggestions saying to make a copy of the InnoDB table in question in a MYISAM table, and then run queries against THAT table and matc...