Full Text Index

[Ryan Belcher]

I am having problems with a FULLTEXT index on a table. I want to change ft_min_word_len to 3 (the default is 4) so I can search for short words. I can do this and sucessfully MATCH() AGAINST() words that are 3 chars long, however string matching no longer seems to work. In other words a string such as "xxxxx yyyyyy" that used to return 1 result with the same MATCH() AGAINST() no longer returns that result (note this happens with string in which all words are over 4 chars).

To change ft_min_word_len I added this line to my.cnf

ft_min_word_len=3

then restarted mysql and did a REPAIR TABLE on the table I am querying.

I am using

mysql Ver 14.7 Distrib 4.1.13, for pc-linux-gnu (i686) using readline 4.3

on Fedora Core 3.

Thanks