How to search by field concatenation in Yii2?

Question

Yii

There is a request to select users by the full name of the form firstname || ' ' || lastname LIKE '%First Name%
' the first name is stored in two firstname-surname fields.
How to make such a query using builder in Yii2? This option swears
->orFilterWhere(['like', 'firstname || \' \' || lastname', $text]);
column \"firstname || ' ' || lastname\" does not exist

Answer 1

->addSelect(['*', CONCAT('firstname', 'lastname') as full_name])->andFilterWhere(['like', 'full_name', $text])