Build Condition Using Cdbcriteria

Yii 1.1 General Discussion
1

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)

2 

$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);
3

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);
4

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;