Description of MySQL full-text index restrictions

The following articles mainly describe MySQL full-text index restrictions. We all know that MySQL 4.0 supports full-text indexing, but the default minimum index length of MySQL database 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.

The above content is an introduction to MySQL full-text index restrictions. I hope you will find some gains.