MySQL will not search for words less than 4 characters (like egg, car, bat, ok, yes, no, etc), if you are using full text search. This happens because of a default setting.
There is a configuration file called my.cnf. Make setting here
[mysqld]
fit_min_word_len = 3
then it will search for words with 3 letters also. After making this change, restart your Apache server or IIS server, maybe also the MySQL server.
Read more:
http://tech.lds.org/forum/showthread.php?t=520
But the problem with me is that I have installed MySQL by XAMPP package and the C:\xampp\mysql directory does not contain the my.cnf file. Seems that if you install it without XAMPP then it must be there.
Could someone tell me why I dont have my.cnf file on my installation??
Edited 1 time(s). Last edit at 03/21/2009 05:50AM by Abhishek Kumar.