Remove mysql full-text index restrictions

Mysql supports full-text indexing, but the default minimum index length of Mysql is 4. This setting is reasonable for English, but unreasonable for Chinese or Japanese. So, modify mysql configuration (my. cnf file): add a line of fft_min_word_lennn numbers smaller than 4 after [mysqld ].

Mysql 4.0 supports full-text indexing, but the default minimum index length of Mysql is 4. This setting is reasonable for English, but unreasonable for Chinese or Japanese. So, modify mysql configuration (my. cnf file): add a line of fft_min_word_len = n less than 4 after [mysqld]

Mysql 4.0 supports full-text indexing, but the default minimum index length of Mysql is 4.

This setting is reasonable for English, but unreasonable for Chinese or Japanese.

So, modify the mysql configuration (my. cnf file ):

Add a line after [mysqld]

Fft_min_word_len = n

N is a number smaller than 4. Restart mysql.