CODEWITHSUNDEEP
mysqlstop-words
Avinash
Avinash

Reputation: 6174

How can I write full search index query which will not consider any stopwords?

I have written a query which will perform Full Text search using full search Index in mysql Table.

But my problem is that when user searches with "to go" then it will not search anything because of stopwords in mysql.

So my question is, how can I write a Full Search query which will ignore the stopwords?

Upvotes: 1

Views: 1878

Answers (1)

Robert Harvey
Robert Harvey

Reputation: 180948

To override the default stopword list, set the ft_stopword_file system variable. (See Section 5.1.4, “Server System Variables”.) The variable value should be the path name of the file containing the stopword list, or the empty string to disable stopword filtering. The server looks for the file in the data directory unless an absolute path name is given to specify a different directory. After changing the value of this variable or the contents of the stopword file, restart the server and rebuild your FULLTEXT indexes.

http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html

Upvotes: 2

Related Questions