MySQL query problem, like the reverse use?

MySQL like

There's no such statement

Like what

$str = "Hello, have you eaten today?" steamed bun or a pancake? Bun inside also a little vitamin than cake good ";

database table t1 is stored in the
ID Name
1 Vitamins
2 Eat
3 Sport
4 Entertainment

What statements can be used to match the use of $str from the T1 to take vitamins and eat?

Reply to discussion (solution)

There's a locate function in MYSQL.

SELECT * from t1 where Find_in_set (name, $STR)

SELECT * from T1 WHERE $str like CONCAT ('% ', name, '% ');

