Re: sample for query with multiple search fields
| From: | Mukul Sabharwal | Date: | Mon, 16 Oct 2000 14:21:11 +0000 |
| Subject: | Re: sample for query with multiple search fields | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-20372@lists.php.net to get a copy of this message | ||
it's simple
SELECT * FROM table WHERE Col1 LIKE '%pat%' OR COL2
LIKE '%name%'
as many columns as there are.... colnth...
--- ott89@t-online.de wrote: > Does anybody know a
sample-script for a
> search-using multiple fields in a
> mysql-search-query?
>
> Thank you.
>
> Regards
>
> Helmut
>
>
>
>
=====
To Find Out More About Me : http://mukul.tsx.org/
__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/