mysql full-text search - Disable Stop words

by raja 2009-08-20 12:39:27

Disable the default stopwords 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_stopword_file = ""

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).

Tagged in:

2419
like
0
dislike
0
mail
flag

You must LOGIN to add comments