How to make a search not by the exact occurrence of the search word?

Question

MySQL

Hello! I know that in yii2 it's better to use the sphynx library to search the site, but now I'm doing it manually with the following request:

$query = Pages::find()->where(['like', 'title', $q]);

This query returns an exact match, i.e. if you need to find "12345", then the query "123" will return nothing. In simple mysql, the query would be built something like this

$sql = "SELECT title FROM pages WHERE title LIKE '%" . $q . "%' ";

Here's how to enter these '%" . $q . "%' in a yii2 query?

Answer 1

How to write "left" and "right" LIKE in ActiveQuery Yii2?

Answer 2

If you did it through the GRUD generator in gii, then you should have created a certain NameSearch class.
Connect to it in any way convenient for you, I used the DetailView and ListView widgets. In principle, skillfully, you can display information in any form. A minimum of code, numbering, pagination, recalculation of the number of displayed records, you can form the appearance as you want, such moments are already provided in the search class. I don’t know about others, for any coincidence I displayed infa, even one character at a time, at least 3 characters, it doesn’t matter)))