[alexd2]

In a conditional use mysql to do so

SELECT IF (data> 2, data, 3) WHERE status = 1

As you can add if (data> 2, data, 3) criteria?

[Keith]

I don't understand the question, can you try to restate it?

As an aside, in MySQL, you can use GREATEST():

SELECT GREATEST(data, 3) WHERE status = 1

[alex-w]

Think this will work.

MyModel::model()->find([
  'select' => ['IF(data>2, data, 3) AS data'],
  'condition' => 'status=1'
]);

[alexd2]

alex-w, on 05 October 2012 - 09:41 AM, said:

Think this will work.

MyModel::model()->find([
  'select' => ['IF(data>2, data, 3) AS data'],
  'condition' => 'status=1'
]);

If that's the idea, I'll try it and see if it works.

[alexd2]

//Model
class Mytest extends CActiveRecord
{
public $newdata;
...
...

$criteria=new CDbCriteria;
$criteria->select = array("*"," if(data > 2, data, 3) AS newdata");
...
...
}

It's work...