I am using full_index search on mysql for searching my site. There is a known limitation that with full_index, you can not search for a word with three characters or less. I want to work around this issue and need some ideas on how to resolve this using mysql and php. I want to be able to search for 'car', 'bmw', 'si', etc. If you know a way please let me know here.
I found the answer, you have to edit your 'my.cnf' file and add following statement Visit http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html for details.