How to do a search by name?

Question

PHP

Good afternoon.
I'm trying to search for a movie title in the database with the following SQL query:

// [name] => Проект засекречен / Проект «Синяя книга»
$connection->table('serials')
                  ->where('name', 'LIKE', '%синяя книга%')
                  ->get();

Zero results after execution .
BUT , if you leave only the "book" he will successfully find. And again BUT, if instead of "book" you make a request "blue" - the request will return nothing again.
Everything is bad with sql, so I ask you to tell me how to make a "search by name", where, for example, there is the name "Castle Rock", and you can score in the search as "Castle Rock" ..

Answer 1

After half a day, I found a solution to the problem.
I made a custom function for converting a string to lowercase, since lower() refused to work with Cyrillic.

... 

function mb_lower($str) {
    return mb_strtolower($str);
}

// Если используется PDO:SQLite
$db->sqliteCreateFunction('mb_lower', 'mb_lower', 1);

// Если используется расшриение SQLite3 
// $db->createFunction('mb_lower', 'mb_lower');

$sql = 'SELECT name, season, episode FROM serials WHERE mb_lower(name) LIKE mb_lower("%хОдЯчиЕе МеРТВЕЦЫ%")';

...

Now everything works as it should =)

Answer 2

Could it be a case problem? Try a case-insensitive search and if it works, use the solution from the answer
https://stackoverflow.com/a/2876820

Answer 3

learn what % is in the query
then you will learn how to compose
'%blue%book%'
'blue%book%' - works faster
'blue%book%' etc.
with Karsluhe it is more difficult - this is done by fuzzy matching and synonyms in full-text search systems
and yes - in Muskul it is better to use www.mysql.ru/docs/man/Fulltext_Search.html