Disable Stopwords

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
lenton
Forum Commoner
Posts: 49
Joined: Sun Jun 20, 2010 6:45 am

Disable Stopwords

Post 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.
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: Disable Stopwords

Post by AbraCadaver »

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.
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Disable Stopwords

Post 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.
There are 10 types of people in this world, those who understand binary and those who don't
Post Reply