yii CDbCriteria examples

yii criteria

<?php

$criteria=new CDbCriteria;
$criteria->addSearchCondition('title', $_GET['Press']['title']);
$criteria->addSearchCondition('body', $_GET['Press']['title']);
$presses=Press::model()->findAll($criteria);
// SELECT * FROM 'presses' 't' WHERE (title LIKE :ycp0) AND (body LIKE :ycp1)


$criteria=new CDbCriteria;
$criteria->addSearchCondition('title', $_GET['Press']['title'], true, 'OR');
$criteria->addSearchCondition('body', $_GET['Press']['title'], true, 'OR');
$presses=Press::model()->findAll($criteria);
// SELECT * FROM 'presses' 't' WHERE (title LIKE :ycp0) OR (body LIKE :ycp1)

$criteria=new CDbCriteria;
$criteria->compare('title', $_GET['Press']['title'], true, 'OR');
$criteria->compare('body', $_GET['Press']['title'], true, 'OR');
$presses=Press::model()->findAll($criteria);
// SELECT * FROM 'presses' 't' WHERE (title LIKE :ycp0) OR (body LIKE :ycp1)

// with dates
$now = new CDbExpression("NOW()");
$criteria->addCondition('exp_d > '.$now);



?>