Fulltext search with prefix %like%

[Ray]

I do boolean searches using the following format "SELECT field FROM table WHERE MATCH (columnName) AGAINST ('+search* +phrases*' IN BOOLEAN MODE)"

I want to be able to find results where the phrases "search" and "phrases" are in the end of the words as well. Currently, the results only return records where "search" and "phrases" are at the beginning of the words.

It will return a record with a value of

"searching for phrases"

but not for

"anothersearch for morephrases"

I want something similar to the "%search%" and "%phrases%" results when using a LIKE statement.

With thanks
Ray