MySQL – How to change the FULLTEXT SEARCH 4 character minimum behaviour

Thursday, January 14, 2010 23:56
Posted in category Database

By default the FULLTEXT minimum characters behaviour is set to 4 characters. To check what value is preset on your server type the following query:

SHOW VARIABLES LIKE ‘ft%’;

That shoud bring up a result similar to this:

Variable_name Value
ft_boolean_syntax + -><()~*:”"&|
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (built-in)

To change the ftp_min_word_len you have to edit the my.ini configuration file.
Below [mysqld] add this line to decrease the min. word length to 3 characters:

ft_min_word_len = 3

Restart your server and rebuild the existing indexes by using the following query:

REPAIR TABLE tableNameHere QUICK;

You can leave a response, or trackback from your own site.

Leave a Reply

Connect with Facebook