IN query for ActiveRecord


I am wonder what’s the best way to do an IN query using Yii ActiveRecord. For example, I have an array and it has a list PK value of a table. I want to find all the records whose PK value are in the array.

What’s the Yii’s way to accomplish this.



You could pass a CDbCriteria.

$values = array(1, 2, 3);

$criteria = new CDbCriteria;

$criteria->addInCondition('id', $values);

$results = Model::model()->findAll($criteria);

Insert the values you want into values change ‘id’ to whatever the PK is called.

Hope I’ve helped.

thanks for the pointer, I will try it out. I am sure it works.