MySQL full text search with partial words
My understanding is that MySQL FULLTEXT indexes support searching for prefixes (MATCH (a.article_name) AGAINST ('MySQL*' IN BOOLEAN MODE)) only.
Quoting from MySQL manual:"The search result is empty because the word “MySQL” is present in at least 50% of the rows."http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html