Jump to content

Archived

This topic is now archived and is closed to further replies.

cheryl

wild search

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.