How to search for text in two bd fields?

Question

Yii

public function searchByName(){
    $criteria = new CDbCriteria;
    $criteria->compare("name_ru", 'петух', true);
    $criteria->compare('name_en', 'петух' ,true);
    return new CActiveDataProvider($this, array(
      'criteria'=>$criteria,
      ));
  }

Answer 1

Maybe you need this:

$criteria->addSearchCondition('name_ru','петух');
$criteria->addSearchCondition('name_en','петух',true,'OR);

here is a link on the topic yiiframework.ru/forum/viewtopic.php?t=7672