wild search

[cheryl]

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.

[fenway]

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?