$ criteria->在yii中选择

Question

Is it possible to do the following in yii

$criteria=new CDbCriteria;
$criteria->select='avg(rate) as avgRate,rate';

I executed the following code but its returning the value for the column "rate" but not "avgRate" I know this could be done by createcommand but I want to use CDbCriteria.

Answer 1

try this

$criteria->select = array('rate', 'avg(rate) as avgRate');

And don't forget to define $avgRate as a public variable in your model.