Guest Posted July 2, 2008 Share Posted July 2, 2008 I want to lookup out of the database just a few letters of a word like I want orl to pull up orlando I have a fulltext index but its only doing full words how can I make it do this? Quote Link to comment Share on other sites More sharing options...
Vikas Jayna Posted July 2, 2008 Share Posted July 2, 2008 Try using regexp - http://dev.mysql.com/doc/refman/5.0/en/regexp.html Quote Link to comment Share on other sites More sharing options...
bluejay002 Posted July 2, 2008 Share Posted July 2, 2008 use '%'... there are other wildcards available and you might want to check those. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.