Конструции SELECT

$id = 25;     
$result = Apartment::model()->findByPk($id);  
echo $result->title_ru;  

$ids = array(25, 26, 27);     
$result = Apartment::model()->findAllByPk($ids);  
 
foreach ($result as $item) {  
    echo '<pre>';  
    print_r($item->title_ru);  
    echo '</pre>';  
}  

Плохой пример применения

$result = Apartment::model()->findByAttributes(array('title_ru' => 'Однокомнатная квартира на Новом Арбате'));  
 
echo $result->title_ru;  
echo '<br>'.$result->id;  

Хороший

$result = User::model()->findByAttributes(array('name' => 'admin@mirocow.com')); 

Дело в том что findByAttributes равносильно =, а не LIKE

$result = Apartment::model()->findAllByAttributes(array('title_ru' => array('Однокомнатная квартира на Новом Арбате', 'дом на ул. Трубецкая')));  
 
foreach ($result as $item) {  
    echo '<pre>';  
    print_r($item->title_ru);  
    print_r('<br>'.$item->id);  
    echo '</pre>';  
} 

$result = Apartment::model()->findAllByAttributes(
  array(
    'id' => array(19, 20), 
    'title_ru' => array('Однокомнатная квартира на Новом Арбате', 'дом на ул. Трубецкая')
  ));  
 
foreach ($result as $item) {  
    echo '<pre>';  
    print_r($item->title_ru);  
    print_r('<br>'.$item->id);  
    echo '</pre>';  
}  

$numMax = 19;     
$result = Apartment::model()->find('id < :numMax', array(':numMax' => $numMax));  
 
echo $result->title_ru;  
echo '<br>'.$result->id;  

$numMax = 20;     
$result = Apartment::model()->findAll('id < :numMax', array(':numMax' => $numMax));  
 
foreach ($result as $item) {  
    echo '<pre>';  
    print_r($item->title_ru);  
    print_r('<br>'.$item->id);  
    echo '</pre>';  
}

$numMax = 20;     
$result = Apartment::model()->findAll("id < {$numMax}");  
 
foreach ($result as $item) {  
    echo '<pre>';  
    print_r($item->title_ru);  
    print_r('<br>'.$item->id);  
    echo '</pre>';  
}

$result = Apartment::model()->findAll(array('order' => 'title_ru ASC'));  

$result = Apartment::model()->findBySql('SELECT id FROM {{apartment}} WHERE square = 60 AND title_ru = "квартира на ул. Авиамоторная"');      
echo $result->id;  

$result = Apartment::model()->findAllBySql('SELECT id, title_ru FROM {{apartment}} WHERE square <= 50 AND square >= 40');  
 
foreach ($result as $item) {  
    echo '<pre>';  
    print_r($item->title_ru);  
    print_r('<br>'.$item->id);  
    echo '</pre>';  
}  

$result = Apartment::model()->countBySql('SELECT COUNT(id) FROM {{apartment}} WHERE square <= 50 AND square >= 40');  
echo $result; 

$result = Apartment::model()->count('id < 25');  
echo $result;  

или

$result = Apartment::model()->count('id < :num', array(':num' => 25));  
echo $result;  

$result = Apartment::model()->exists('id < :num', array(':num' => 25));  
echo var_dump($result); 

или

$result = Apartment::model()->exists('id < :num', array(':num' => 1));  
echo var_dump($result);  

$ids = array(18, 19, 20);     
$result = Apartment::model()->updateByPk($ids, array('title_ru' => 'Новый заголовок'));   

$result = Apartment::model()->updateAll(array('title_ru' => 'Новый заголовок'), 'title_ru = :title', array(':title' => 'квартира на ул. Авиамоторная'));

$result = Apartment::model()->deleteByPk(18);  

$result = Apartment::model()->deleteAll('title_ru = :title', array(':title' => 'дом на ул. Трубецкая'));