Full-text search with Stopwords in MySQL

Question

I am using Full-Text search in MySQL. But when search it with Stopword result is empty.

What I want is operation like what we use with LIKE. Mean that, it do with all word. After I used Full-Text search, I think that it more powerful than LIKE, it can use with index FULLTEXT, with multiple field.

But, when search criteria in AGAINST is in list of Stopwords the result is EMPTY.

How can I use Full-Text search in MySQL that filter although word in Stopword? Or Others way that I can use with search algorithm?

I really need solution but still have no answers on my question... — KH-DP, Oct 25 '12 at 07:33

score 0 · Answer 1 · answered Nov 05 '12 at 22:22

0

The only way I can think of is to mess with the ft_stopword_file system variable. Notice in particular:

Setting this variable to the empty string ('') disables stopword filtering

Unfortunately, this setting cannot be changed on the fly, mostly because fulltext indexes must be rebuilt after changing it.

answered Nov 05 '12 at 22:22

RandomSeed

29,301
6
52
87

so it still have no solution? – KH-DP Nov 06 '12 at 03:58
1

@KH-DP Yes, this is a solution, despite the drawbacks. – RandomSeed Nov 06 '12 at 19:36
1

You could disable stopword filtering, and when you want stopword filtering on, filter out all stopwords before-hand in whatever language you're using when connecting to your MySQL server, if you are. – Timothy Zorn Sep 02 '14 at 19:08

Full-text search with Stopwords in MySQL

1 Answers1