MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: How to change ft_min_word_len variable ?  (Read 4253 times)

0 Members and 1 Guest are viewing this topic.

Offline Dipak Bhoi

  • MilesWeb Team Member
  • Full Member
  • ***
  • Posts: 208
  • Karma: +5/-0
    • View Profile
    • MilesWeb Internet Services
How to change ft_min_word_len variable ?
« on: August 31, 2014, 07:44:25 PM »
Hello guys,

If you would like to change the minimum word length for full text search in mysql, then add the following line into mysql configuration file.

MySQL config file would usually be found on Linux under /etc/my.cnf Edit the file and add following line or change if already exist.

Quote
[mysqld]
ft_min_word_len = 3

The default value is 4 and the above will change it to 3.

After changing the variable in config file restart MySQL server and you're done. You can then check the values in phpMyAdmin under "Show MySQL system variables" to make sure your changes have taken place.

Enjoy !!

MilesWeb.com
cPanel Hosting in India - cPanel Hosting in India.

Grab an SSL for your website and SAVE 20% now. Coupon Code SSLSAVE20.

MilesWeb Hosting Forum

How to change ft_min_word_len variable ?
« on: August 31, 2014, 07:44:25 PM »