How to do a search by matching two or more words anywhere in mysql?

Question

PHP

How to do a search by matching two or more words anywhere in mysql?
In this case, he is looking for matches of the entire sentence %$text%
. If we enter "Potato from Armenia" in the search, in the line Хорошая картошка из армении- he will find a match, but
in the search Картошка хорошая из армении, he will not find it.

How to search by matching all words in any sequence?

Answer 1

SELECT * FROM test 
           WHERE SOUNDEX(name) 
LIKE CONCAT('%',SUBSTRING(SOUNDEX('Картошка хорошая из армении'),2),'%');

Source

Answer 2

Learning to use the Internet