Yii: deleteAll and IN statement

Question

I have an array with identifiers and want to delete all of them with id

$membersId = array('1','2','3'); $inStatement = implode(',', $membersId); //dont work! TRatingMembers::model()->deleteAll(array('member_id IN (:member_id)'), array(':member_id' => $inStatement)); 

How to delete all rows with one transaction?

Answer 1

 $criteria = new CDbCriteria; $criteria->addInCondition('member_id',$membersId); TRatingMembers::model()->deleteAll($criteria); 

http://www.yiiframework.com/doc/api/1.1/CDbCriteria#addInCondition-detail

Answer 2

 if (!empty(membersId)) { $memberIds = implode(', ', $membersId); TRatingMembers::model()->deleteAll('member_id IN (' . $memberIds . ')'); }