I have a full text search set up between 3 colums and this is working fine, however I would like to be able to wrap the keywords with wildcards to return part of words such as returning "fish" within "fishing"
On a normal search i would go WHERE mycolum LIKE '%fish%'
but is it possible to do so with a fulltext search?

Thanking you in advance,