How to reset stop words in MYSQL?

mysql database search full-text-search stop-words
Prashant picture Prashant · Apr 28, 2009 · Viewed 9.2k times · Source

I want to reset stop word list in mysql for FULLTEXT search. I have installed WAMP Server in my system which have phpmyadmin to access mysql. But I dont know how to reset stop word in phpmyadmin. Can anyone please tell me how to do that.

I also http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_ft_stopword_file read this link but don't know ho wto use this ???

Answer

Aziz picture Aziz · Apr 28, 2009

I assume you're using WampServer.

Click the tray icon, select MySQL, then click my.ini. The configuration file will open in notepad. Go to the end of the file and add this line (after the port line):

 ft_stopword_file=''

to disable stop words. If you want to use custom stop-word file, replace that line with:

ft_stopword_file='path/to/stopword_file.txt'

(set the path of the stopword file, of course).

After setting that line, save the configuration file (File -> Save). Then click the tray icon, select MySQL, then Service, then click Restart Service.

To Ensure that your configuration is done correctly, open phpMyAdmin in the browser, click on the Variables tab at the top, then find ft stopword file and see the values that is set to it.

Related questions

Implementation of Levenshtein distance for mysql/fuzzy search?

I would like to be able to search a table as follows for smith as get everything that it within 1 variance. Data: O'Brien Smithe Dolan Smuth Wong Smoth Gunther Smiht I have looked into using Levenshtein distance does anyone know …

Read More
how B-tree indexing works in mysql

When I create an index for a table in mysql, I see that the index_type is type BTREE. Now although I understand about btree(s), I do not quiet understand how it stores the index and how the database …

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More