Yii2 compose query via LIKE?

Question

Yii

Hello.
You need to make a query like this:

SELECT * FROM news WHERE date_news LIKE '____-$var-__';

I write like this:

$events = News::find()
                ->where(['LIKE', 'date_news', '____-' . $incident . '-__'])
                ->all();

In this case, nothing comes out. In yii-debug this is:

SELECT * FROM `news` WHERE `date_news` LIKE '%\\_\\_\\_\\_-12-\\_\\_%'

How to change?
I can write like this

$events = News::find()
                ->where("date_news LIKE '____-$incident-__' ")
                ->all();

And everything will work, but I want to write the request correctly.

Answer 1

If so?

$events = News::find()
                ->where(['LIKE', 'date_news', '____-' . $incident . '-__', false])
                ->all();

www.yiiframework.com/doc-2.0/yii-db-query.html#whe...