|
|
mysql full-text search - Changing minimum word length - Mysql
|
Views : 1418
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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).
|
|
By raja, On - 2009-08-20 |
|
|
|
