full-text index issue in mysql 5

I was having issues with full-text index using MySQL 5.  Basically, on one host I would see results with the same query but not on another host. Here is the sample query I used:

SELECT * from table_name WHERE MATCH(Description, Title) AGAINST (‘yes” IN BOOLEAN MODE) AND title like ‘%yes%’ ;

Because the length of the text I was indexing was three characters, I though it may have to do with the MySQL settings.  I found that ft_min_word_len was set to 4  If I change this setting to be ft_min_word_len=3, it should work.

More details on the above here:

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

Mysql will need to be restarted after making the configuration change.  I may have to rebuild the index as well by using something like

REPAIR TABLE table_name;

I’ll let you know if this works. ** It works!

---

Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically each day to your feed reader.

awakash.com | Powered by WordPress