Disable stopwords in mysql Full text index

if you didn’t know what full text index for mysql is google it.

It makes searches for text much faster than using “where text like ‘%keywod1%’ AND text like ‘%keyword2%’. (at least 100 times faster)

That trick saved me in a when I had an overloaded server.

Anyway, the bad thing is that there are a lot of stopwords, that are ignored if someone makes a search. If you are searching in articles etc, this might be good, but in my case it was just movie titles, so for example “just go with it” returned no results.

Fortunately for me a friend that has similar websites to mine, told me how to fix the problem. So to fix this, just open my.cnf and add that line:

ft_stopword_file = ''

Then rebuilt indices or run:

REPAIR TABLE tbl_name QUICK