RE: [PHP] MySQL and LIKE?

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) maxim@phpbeginner.com www.phpbeginner.com -----Original Message----- From: Jason Caldwell [mailto:jason@thinkingman.org] Sent: Thursday, April 26, 2001 6:40 AM To: php-general@lists.php.net 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net