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:
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/