I was creating a search, and had a table of 3 rows … and I was literally pulling out hairs. why why why ... then dawned on me AND i feel like a total idiot … mysql FULLTEXT search has a 50% threshold …
If your search returns more than 50% of the rows, then nothing is returned …
And while i have you here … also remember about stop words which will be ignored and also words less than 4 characters
summarizing:
FULLTEXT will save you from writing complex sequence of LIKE or RLIKE and works very well BUT just remember about STOP WORDS and 50% THRESHOLD and that 3 LETTER WORDS are ignored ...