cheryl Posted February 3, 2006 Share Posted February 3, 2006 anyone can help guide or teach on how to do a wild search select statement??[code] $member2 = "SELECT m.memCode,m.memName,c.clientName FROM member m,client c WHERE m.memCode LIKE %_% ORDER BY memCode ASC"; $member_result2 = mysql_query($member2) or die("Couldn't execute query 2."); [/code]is the following correct?? can also follow up on to print the number of records found and print them in table.help please. Link to comment https://forums.phpfreaks.com/topic/3310-wild-search/ Share on other sites More sharing options...
fenway Posted February 3, 2006 Share Posted February 3, 2006 I'm not sure I understand -- that LIKE clause will return any columns that have at least one character in them, though there's an easier/faster way to do that. You do use % and _ in LIKE clauses, but what are you trying to search on? Link to comment https://forums.phpfreaks.com/topic/3310-wild-search/#findComment-11284 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.