How can I build condition like below with CDbCriteria?
(title LIKE :yc0 OR description LIKE :yc0 OR tags LIKE :yc0) AND (user=:yc1 or user=:yc2)
How can I build condition like below with CDbCriteria?
(title LIKE :yc0 OR description LIKE :yc0 OR tags LIKE :yc0) AND (user=:yc1 or user=:yc2)
$c=new CDbCriteria;
$c->compare('title', $term, true, 'OR');
$c->compare('description', $term, true, 'OR');
$c->compare('tags', $term, true);
$c->compare('user', $userTerm, false, 'OR');
$c->compare('user', $userTerm);
Just try this.
$criteria = new CDbCriteria();
$criteria->addCondition((content LIKE :match or title LIKE :match) and (user=:u1 or user=:u2));
$criteria->params = array(':match' => "%$match%",':u1' => $u1,':u2' => $u2);
Solved using :
$criteria->addSearchCondition('title', $value, true, 'OR', 'LIKE');
$criteria->addSearchCondition('description', $value, true, 'OR', 'LIKE');
$criteria->addSearchCondition('tags', $value, true, 'OR', 'LIKE');
$criteria->addCondition('user=:user1 or user-:user2');
$criteria->params[':user1'] = $user1;
$criteria->params[':user2'] = $user2;