I think you should use:
SELECT myTable.col
FROM myTable, otherTable
WHERE myTable.id = otherTable.ID
AND otherTable.data (LIKE "a.%" or LIKE "s.%" or LIKE "io.bean");
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-----Original Message-----
From: Jason Caldwell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 6:40 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL and LIKE?
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]