View Single Post
  #20  
Old December 18th, 2013, 07:10 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

You are up against MySQL again. MySQL has stop words. These are words that do not get indexed because they are so common. The words "all", "in" and "one" are all MySQL stop words. You can see the full list here:

http://dev.mysql.com/doc/refman/5.1/...stopwords.html

There's over 500 stop words.

Here's how to get rid of the stop words feature of MySQL: http://www.nivas.hr/blog/2009/09/15/...ext-stopwords/

Eric