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. Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/3310-wild-search/#findComment-11284 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.