Re[2]: [PHP] php query for mysql table
| From: | Morten Winkler Jørgensen | Date: | Mon, 20 Aug 2001 10:47:25 +0000 |
| Subject: | Re[2]: [PHP] php query for mysql table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-63487@lists.php.net to get a copy of this message | ||
Notice that if a user enters
"life anger"
in the search field
SELECT * FROM table WHERE question LIKE "%life anger%" none of the
questions
>> [1] How do you deal with anger?
>> [2] Ever been full of anger in your life?
>> [3] Is life always easy?
will match. For that you must split the query by " " and perform a
SELECT * FROM table WHERE question LIKE "%life%" OR question LIKE
"%anger%"
or possibly change the OR with a AND.
Kind regards,
Morten Winkler