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'"; 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' Link to comment https://forums.phpfreaks.com/topic/150299-sql-percental-search/#findComment-789439 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.