Код: Выделить всё
$result = Yii::app()->db->createCommand()
->select('id, city, state, district')
->from('geo_cities_all')
->where('country_id=:country_id AND city LIKE :city', array(':country_id'=>$country_id, ':city'=>'%'.$value.'%'))
->queryAll();