convert MySql Query to yii framework Query system

Question

I want to convert this SQL query to CDbCriteria format in Yii framework so I can use it in Yii:

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

Yiiframework CDbCriteria Description Link is as below:

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

Just a heads-up: the above query will ignore records with only 'to' as the title. You might want to include a condition for this. — topher
– topher, Commented Jan 27, 2013 at 22:50

amirmohammad · Accepted Answer · 2013-05-04 10:11:09Z

4

also you can try this

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

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

edited May 4, 2013 at 10:11

answered Jan 28, 2013 at 11:21

amirmohammad

3743 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MrSoundless Over a year ago

This works only if you add a 3th param to compare with value 'true'

WebDevPT Over a year ago

CDbCritera should be CDbCriteria

schmunk · Accepted Answer · 2013-05-02 13:15:06Z

2

Here you go:

$criteria = new CDbCriteria;
$criteria->select = "title";
$criteria->condition = "((title like ':to%') or (title like ' % :to %') or (title like '% :to'))";
$criteria->params = array(':to' => 'to');

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

edited May 2, 2013 at 13:15

answered Jan 26, 2013 at 20:22

schmunk

4,7181 gold badge30 silver badges50 bronze badges

1 Comment

WebDevPT Over a year ago

CDbCritera should be CDbCriteria

Collectives™ on Stack Overflow

convert MySql Query to yii framework Query system

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related