MySql functions and Active Record

Yii 1.1 General Discussion
1

Hello, everybody.

Is it possiblle to use MySql functions (for example STR_TO_DATE(str,format)) within CActiveRecord object?

Thanks.

2

You can do this:




$user = User::model()->findByPk(1);

$user->someDate = new CDbExpression("ANY VALID SQL COMMAND");

$user->save();
3

Y!!, thank you for your quick reply.

It works greate. :)

4

No problem. You may also bind params for security reasons.


new CDbExpression("MD5(:example)", array(':example' => $example));