It's more concerning than that. A quick squizz at the source code says "and" is a stopword.
...skip 23 words ... am among amongst an
and
another any anybody anyhow
... skip 511 words
Oh, wait, that's the myisam implementation: storage/myisam/ft_static.cc
(not ft_stopwords.cc
it turns out).
Yeah.... different storage engines do full-text search differently. Let's see if they use different lists of stopwords, too Refactoring? What's that?.
Let's look under innodb: Um, that would be storage/innobase/fts
I suppose.
/** InnoDB default stopword list:
There are different versions of stopwords, the stop words listed
below comes from "Google Stopword" list. Reference:
http://meta.wikimedia.org/wiki/Stop_word_list/google_stop_word_list.
The final version of InnoDB default stopword list is still pending
for decision */
const char *fts_default_stopword[] = {
"a", "about", "an", "are", "as", "at", "be", "by",
"com", "de", "en", "for", "from", "how", "i", "in",
"is", "it", "la", "of", "on", "or", "that", "the",
"this", "to", "was", "what", "when", "where", "who", "will",
"with", "und", "the", "www", NULL};
(from fts0fts.cc
)
For extra giggles, have a look at the list referenced in the comment. "Pending for decision". This list in its current form and that comment are at least eight years old.
<Insomniak`> Stupid Google
<Insomniak`> "The" is a common word, and was not included in your search
<Insomniak`> "Who" is a common word, and was not included in your search
http://bash.org/?514353