SELECT a.title,b.title
FROM test2 b
LEFT JOIN test1 a
ON b.title
LIKE CONCAT('%',a.title,'%')
CONCAT作为连接两个并列的变量。eg:CONCAT(a,b) 意为 a || b
SELECT a.title,b.title
FROM test2 b
LEFT JOIN test1 a
ON b.title
LIKE CONCAT('%',a.title,'%')
CONCAT作为连接两个并列的变量。eg:CONCAT(a,b) 意为 a || b