All geek questions in one place

Mysql matches the query

I use mysql matching with a query in my search query like this

MATCH(film_name) AGAINST ('the vacation' IN BOOLEAN MODE).

But before I used this

film_name like '%the vacation%'

So, my question is that I get the correct result using the coincidence and contra, but the problem is that when I use, as there, I can use the character %before and after the search string, so if the search string is present in the string, then it returned the result, so plz will tell you how to write mine " MATCH(film_name) AGAINST ('the vacation' IN BOOLEAN MODE) "so that it also behaves like "%".

If the file name is "rocketsingh"

then if I run film_name like '%rocket%', then it will show me the result

but if I run MATCH(film_name) AGAINST ('rocket' IN BOOLEAN MODE), then it will not show any result. Please suggest what to do.

+3
2

MATCH , wilcards. , postfix , . * , .

+2

: . MATCH AGAINST , . . , vacation, the, vacation the the something something vacation . , .

LIKE, .

0

Source: https://habr.com/ru/post/1770108/

More articles:


All Articles