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? Link to comment https://forums.phpfreaks.com/topic/112882-fulltext-search/ 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 Link to comment https://forums.phpfreaks.com/topic/112882-fulltext-search/#findComment-579817 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. Link to comment https://forums.phpfreaks.com/topic/112882-fulltext-search/#findComment-579827 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.