php - Processing of reverse LIKE of sql statement

Question

It is normal to use LIKE in SQL statements
But is there any reverse LIKE syntax?
That is to say, it is not the field that contains the string, but the string that contains the field content.
Find out the conditions that meet the conditions.
Please help me!

Answer 1

SELECT *
  FROM 表
 WHERE '字符串' LIKE CONCAT('%',字段,'%')