24K Design Studio :: Blog :: Modify minimum search length of MySQL
Author:
Password:
Modify minimum search length of MySQL
01:06, 13 Jan, 2013
by James

MySQL by default requires minimum of 4 alphabets to perform a search.

Here is a way to modify the minimum number on CentOS:

# mysql -u root

# nano /etc/my.cnf

add the below line and save it, the number indicate the minimum length for the search, here we put 3.

ft_min_word_len=3

# service mysqld restart

rebuild the fulltext index of sql and it should work.

Reply:
Your name:
Only visible to the author.

Tell us you are not a robot. What is captcha1captchaOcaptcha2 =

Reply