mySQL Query - comparing multiple values with one field
| From: | Niklas Lampén | Date: | Wed, 22 Aug 2001 06:51:26 +0000 |
| Subject: | mySQL Query - comparing multiple values with one field | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-63863@lists.php.net to get a copy of this message | ||
What I need to do is to compare if one field matches a value from a huge
list of values.
Do I need to query like
"SELECT * FROM table WHERE field LIKE '%value1%' || field LIKE
'%value2%'"
or can I do it something like this
"SELECT * FROM table WHERE field LIKE ('%value1%' || '%value2%')"?
Niklas Lampén