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.
Disable Stopwords
Moderator: General Moderators
- AbraCadaver
- DevNet Master
- Posts: 2572
- Joined: Mon Feb 24, 2003 10:12 am
- Location: The Republic of Texas
- Contact:
Re: Disable Stopwords
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Re: Disable Stopwords
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.
There are 10 types of people in this world, those who understand binary and those who don't