Multiple WHERE (=, LIKE)
Posted: Mon Dec 27, 2004 11:30 am
I need to have a query that checks for one field to be equal while other fields be LIKE. Here is my query, it is disregarding the = check.
Any ideas?
Code: Select all
"SELECT * FROM con_articles WHERE active = 'Y' AND common LIKE " . $search1 . " OR common LIKE " . $search2 . " OR common LIKE " . $search3 . ""