godsent Posted March 20, 2009 Share Posted March 20, 2009 is where any way to search SQL tables if you missed like 1 letter in the word. And if possible how should it look like? $query = "SELECT * FROM list WHERE `name`= '$search'"; Quote Link to comment https://forums.phpfreaks.com/topic/150299-sql-percental-search/ Share on other sites More sharing options...
rhodesa Posted March 20, 2009 Share Posted March 20, 2009 with MySQL, there are two wildcards: % and _ http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html so the following would match 'test': WHERE colname LIKE 't_st' Quote Link to comment https://forums.phpfreaks.com/topic/150299-sql-percental-search/#findComment-789439 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.