Page 1 of 1

Disable Stopwords

Posted: Wed Jul 13, 2011 3:52 pm
by lenton
On fulltext searches, MYSQL by default ignores short words such a 'the', 'is', 'by', 'little', etc.

I own a music search engine and this stops me from finding a song like "little by little".

How can I disable MYSQL stopwords? Thanks for your help.

Re: Disable Stopwords

Posted: Wed Jul 13, 2011 4:09 pm
by AbraCadaver

Re: Disable Stopwords

Posted: Wed Jul 20, 2011 2:35 am
by VladSun
Unfortunately, I think it's system wide setting - i.e. if you are on a shared hosting server, probably you can't do anything. Another setting that may "break" your searches is the threshold for natural language searches - a 50% hardcoded value. I.e. even if you succeed changing the stop-words list, some results will not be shown (or not shown accurately) because some words have been ignored due to this threshold.