php - 将 MySql Query 转换为 yii 框架查询系统

Question

我想在 Yii 框架中将此 SQL 查询转换为 CDbCriteria 格式，以便在 Yii 中使用它:

SELECT title FROM project WHERE ((title like 'to %') or (title like ' % to %') or (title like '% to'));

Yiiframework CDbCriteria 描述链接如下:

http://www.yiiframework.com/doc/api/1.1/CDbCriteria

Answer 1

你也可以试试这个

$criteria = new CDbCriteria;
$criteria->select = "title";
$criteria->compare('title',' to ',true);

$model = new Project;
$models = $model->findAll($criteria);