I'm new to FULL-TEXT searching, although I've been programing using MySQL & PHP for a number of years.
I'm trying to do a search on a database, and doing a basic search returns a number of results:
"SELECT * FROM table1 WHERE data like 'test'"
this returns about 20 results, which includes records with both 'Test' & 'test'. However, doing a full-text search returns an empty set:
"SELECT *, MATCH(data) AGAINST ('test') AS score FROM table1 WHERE MATCH(data) AGANIST ('test')"
I have a similar query working that does return results on another table using:
"SELECT ticket_id, MATCH(keywords,details) AGAINST ('test') AS score FROM table2 WHERE MATCH(keywords,details) AGANIST ('test')".
I don't understand how the simple search is returning results, when the full-text doesn't. Am I formatting the query incorrectly?