mysql:转身就好

Question

我有一张这样的 table

id, title1, hello world2, world hello

and i like to search for all ids that matches this php expression:

$searchstring = "hello world is yours"
if (strstr($searchstring,mysql(title)){echo found}

在mysql中我经常使用这个:

select id from table where title LIKE '%....%'

但我需要它的另一边:

select id from table where "hello word is yours" LIKE %title%

结果必须是id 1 "hello word"

谁能告诉我正确的语法？

Answer 1

select id from table
where 'hello word is yours' LIKE concat('%', replace(title, ' ', '%'), '%')