MysqlWord searching

SELECT * FROM articles WHERE MATCH (title,body)
-> AGAINST ('*apple*' IN BOOLEAN MODE);

so that we would get back results:

appleby
appleseed
bigapple
redapple