CDbCriteria Simple

$criteria=new CDbCriteria;
$criteria->select = "priority";
$criteria->order = "priority desc";
return new CActiveDataProvider($model, array(   'criteria'=>$criteria,  ));

-----
$criteria=new CDbCriteria;
$criteria->compare('year(`EventStartdate`)','>=:'.$currentYear); 
$criteria->compare('year(`EventStartdate`)','>='.$currentYear); 

-----
$criteria = new CDbCriteria;
$criteria->condition = 'foo = 1 OR bar = 2';
$models = TableName::model()->findAll($criteria);

-----
$criteria=new CDbCriteria;
       /** together **/
$criteria->together=true;      
       /** with **/  
$criteria->with=array('tbl_user');
       /** inner join **/
$criteria->join="INNER JOIN tbl_user as user ON(user.userid=t.user_id)";                
        
       /** compare **/
$criteria->compare('t.isactive',$this->isactive,true);
        
       /** addCondition **/
$criteria->addCondition('isactive=1','AND');
        
       /** addInCondition : pass array**/
$criteria->addInCondition('categoryid',$this->categoryid,true);                  
        
        /** addBetweenCondition **/
$criteria->addBetweenCondition("t.createdon",$this->date_after,$this->date_before,"AND");
        
$criteria->addCondition("$condition");                               
---