Hi All,
Having a problem with the MATCH AGAINST type query. Details as follows.
I have a table with 15 fields in it. One of those fields is called 'body' (which i have set to FULLTEXT) and contains all words from all the other fields in that record.
This is the query i am doing:
SELECT * FROM table WHERE MATCH (body) AGAINST ('criteria');
The problem is, that if i have 1 record in the table, it matches no words at all and returns an empty result.
If i have say 10 records in the table, it only matches some of the words.
EG: in the body feidl of one of the records might be the string "the quick brown fox jumped over the lazy dog". If i try to search for the word ''dog" it might work, however it may not work on some of the other words.
I have found no consistency in the way it is behaving.
Any help would be greatly appreciated.
Regards
Dave
