Condition in SQL Query

[npCoda (Sh Humble)]

Can anyone suggest me how to use condition (if … else) in sql query in Yii?

[marcovtwout (Marco van 't Wout)]

Just use createCommand() to create a custom SQL command using the following syntax:

http://www.yiiframework.com/doc/guide/1.1/en/database.dao#binding-parameters

[npCoda (Sh Humble)]

This is not what I want.