How to implement search on 3 fields of YII ActiveRecords like CONCAT_WS(' ', lname,fname,mname) LIKE '%Peter%'?

Question

Yii

Actually, subject, how to make such a condition using yii AR?

Answer 1

The solution turned out to be simple:

$criteria->compare('CONCAT_WS(\' \', t.lname, t.fname, t.mname)', $this->name, true);

Answer 2

Use CDbCriteria->addCondition