1

You are missing something, but it is not obvious. There is a mysql setting called ft_min_word_len (the minimum length of words to be indexed), which defaults to 4. MySQL doc is here. See this post for details on how to change it. (Of course you would want the minimum to be 2). Also from MySQL doc: Note FULLTEXT indexes on MyISAM tables must be rebuilt ...


Only top voted, non community-wiki answers of a minimum length are eligible