Posts Tagged ‘ft_min_word_len’

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

Thursday, January 14, 2010 23:56 No Comments

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 [...]

This was posted under category: Database Tags: , , , , , , , ,