mysql full-text search - Changing minimum word length

Change the minimum word length to be indexed in a mysql full text search :

1. Just open the file /etc/my.cnf file in linux.

In windows, the file will be C:my.ini or C:my.cnf.

2. Add the below line under [mysqld].(There will be other lines also).

ft_min_word_len = 3

This will set the minimum word length to be 3.

3. Save the file and restart the mysql server.

4. Also if you have indexed tables already, you have to drop the full text indices in the table you want to recreate index (Use alter table drop).

5. Create full text index again (Use alter table create index).