I have the following query for searching the tables by car model no and category name
SELECT * FROM CARS as car
LEFT JOIN CATEGORIES as cat
ON cat.car_id = car.car_id
WHERE (car.model_no LIKE '%GT V8%') OR (cat.name LIKE '%GT V8%')
I am using zend framework so I have the query like this so far in my model
$sql = $this->select()->setIntegrityCheck(false)
->from(array('car'=>$this->_name), array())
->joinLeft(array('cat'=>'categories'), 'cat.car_id=car.car_id', array())
then in where clause
I do like this
$sql->where('car.model_no LIKE ?', '%'.$query['search'].'%')
->where('cat.name LIKE ?', '%'.$query['search'].'%')
but that output like
WHERE (car.model_no LIKE '%GT V8%') AND (cat.name LIKE '%GT V8%')
I just can't find a way to replace AND with OR.. Is there anyway to do that in zend_db?