I have a MyISAM table with a full text index. Using:"WITH QUERY EXPANSION" I can only search for full names. However I would like to search for partial names. Sample: I would like to get all the name that contain "hom". This should give me "Thomas" and "Thompson" etc. etc. Any idea on how I can do this?