How to create a reverse like query in Yii2?

Question

Yii

select * from [table] where 'www.site.ru' like [table].[url]
TABLE::find()->where(['like', 'www.site.ru' , 'url']
builds incorrect select
select * from [table] where [www].[site].[ru] like [table].[url]

Answer 1

A little embarrassing

reverse like

, what's this? But it probably means this:

$table_name = 'tapki';
$column_name = 'name';
$query_string = 'паралоновые';
$query = new Query();
$result = $query
         ->from($table_name)
         ->andWhere(['like', $column_name, $query_string])
         ->all();
print_r($result);

it? If yes, then all the magic is described in the docs: https://www.yiiframework.com/doc/guide/2.0/ru/db-q... if not, then specify the question