MySQL and LIKE?
| From: | Jason Caldwell | Date: | Wed, 25 Apr 2001 21:39:53 +0000 |
| Subject: | MySQL and LIKE? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-50368@lists.php.net to get a copy of this message | ||
I'm trying to create a multiple pattern search using LIKE (in mySQL) -- the
following doesn't seem to work and was wondering if someone knew of an easy
efficient way of adding multiple search criteria.
SELECT myTable.col
FROM myTable, otherTable
WHERE myTable.id = otherTable.ID
AND otherTable.data LIKE ("a.%" or "s.%" or "io.bean");
So....
LIKE ("a.%" or "s.%" or "io.bean"); <<- doesn't seem to
work like this.
Thanks.
Jason