Re: Full text search is not working on some values

[Ike Walker]

Certain common words ("stopwords") are not indexed by default, so you won't get hits on those words.

Here is the default stopword list:

http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html

If you want to override the default stopword list, you can create your own list and set it using the ft_stopword_file variable in your config file. More details on ft_stopword_file:

http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

Also, words under a certain length are not indexed. Runs this at the mysql prompt to find out your setting:

show variables like 'ft_min_word_len';