Web Development Blog

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.


# service mysqld restart

rebuild the fulltext index of sql and it should work.

Your name:
Only visible to the author.

Tell us you are not a robot. What is captcha1captchaOcaptcha2

View the latest 5 entries.