I am using the SEARCH AGAINST MySQL syntax in a site I am working on to search several fields for a submitted search. However, it's not working so well for partial matches. My client wants to be able to (for instance) search for a name, such as Smith, and have it find Bob Smith's record in addition to Jim Smithfield.

Here's the actual query:

PHP Code:
MATCH(Issue.keywords,Issue.descriptionAGAINST('{$search}' IN BOOLEAN MODE 
No, the fields aren't names, but that was the best example I can think of. Any thoughts? I appreciate any help that you can offer.