How to formulate a query for entries containing words that are present in the text?

Question

MySQL

I have a similar request, but it works exactly the opposite way: I also tried to solve the problem in php using "strpos()", but I would like to get rid of this crutch. If the question is not at all clear, then I need a record where, when asked for "Hello", I would find a record with the text "priv". Sampling by one column.
SELECT * FROM `TABLE 12` WHERE `Vo` LIKE '%$text%'

Answer 1

match ... against ...
Or, if that's not enough, you can set some sphinx , for example. He is tough.