[PHP] Re: how to do a search in mysql database for multiple keywords?? From: _lallous (elias_bachaalany <email protected>)
Date: 10/15/01

describe your question more...
anyway:

SELECT thetext FROM thetable WHERE
(INSTR(thetext, 'keyword1') <> 0) OR
(INSTR(thetext, 'keyword2') <> 0) OR
(INSTR(thetext, 'keyword3') <> 0);

this will search for either of the three keywords...

"Nicklas Bondesson" <nicke <email protected>> wrote in message
news:20011013133802.49776.qmail <email protected>
> need some help on this. i've come so far that i have split up the variable
> with explode and putting it into an array that looks like this:
> 'keyword1','keyword2'.
>
> but it doesn't doesn't work satisfactory...
>
> any ideas??
>
> /nicke
>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>