How to pull data from a field using text?

Question

Yii

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

if instead of name = rooster I write id=2, then I get all the rules, but I don’t want to by name. Why and how to fix the error?
This is the error that comes out CDbCommand failed to execute the SQL query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rooster' in 'where clause'. The SQL statement executed was: SELECT COUNT(*) FROM `ref_mahala` `t` WHERE name_ru = cock

Answer 1

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

      )
    ));
  }