Can I use array('ordering'=>'ordering+1') in the updateAll?

Yii 1.1 General Discussion
1

I tried,but faild.


$this->model->updateAll(array('ordering'=>'ordering+2'));

I want this:




UPDATE article SET ordering=ordering+1;

Please help!

Thanks!

2

solved by myself

use this:




$this->model->updateAll(array('ordering'=>new CDbExpression('ordering+2')));

this’s work.

3 

$this->model->updateCounters(array('ordering'=>2));