Fulltext Search problem

[Dillenger]

I have a database entry that is 'milestones'

When I used MATCH AGAINST, it will only show up if I type in the exact word 'milestones'. I would like it to be able to come up if someone types in the word 'milestone' or 'mile'. Is this possible at all?

It would be similar to the %LIKE% command, but I want to do it with MATCH AGAINST. Here is what I have currently.

SELECT *  

FROM listings WHERE 

MATCH (listingName) AGAINST ('(milestone)' IN BOOLEAN MODE) AND listings.listingActive = 0 GROUP BY listingID

This returns 0 results.

[NogDog]

You can use the "" character like a wildcard at the end:

. . . AGAINST ('milestone*') IN . . .