Yii: Relation JOIN with MySQL function - how?

Question

Yii

Good day.
There is a model that joins with another model via HAS_ONE
..
'url'=>array(self::HAS_ONE,'Urls','',array('URL'=>'SLUG'))
...
How can I make it so that the model was joined using the MySQL transform function to conditionally get a query like:
select * from A left join B on A.URL=urlize(SLUG);
where urlize is a MySQL stored function.

Answer 1

Have you tried `CDbExpression`?

'url' => array(self::HAS_ONE, 'Urls', array('URL' => new CDbExpression('urlize(`SLUG`)'))),