If you want to change the default minium word size in a MySQL FULLTEXT search.

Find / add the following to ‘my.cnf‘.

ft_min_word_len = 3

Then restart mysql.

Then do a repair on the tables which have FULLTEXT indexes.

This entry was posted on Friday, November 7th, 2008 at 7:10 am and is filed under Linux, Windows. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.