Hello guys,
If you would like to change the minimum word length for full text search in mysql, then add the following line into mysql configuration file.
MySQL config file would usually be found on Linux under /etc/my.cnf Edit the file and add following line or change if already exist.
Quote[mysqld]
ft_min_word_len = 3
The default value is 4 and the above will change it to 3.
After changing the variable in config file restart MySQL server and you're done. You can then check the values in phpMyAdmin under "Show MySQL system variables" to make sure your changes have taken place.
Enjoy !!