Question

mysql让一张表中字段like另一张表中的字段，sql应该怎么写？ 我试了两种方式，都不行

mysql让一张表中字段like另一张表中的字段，sql应该怎么写？
我试了两种方式，都不行：
SELECT a.*,b.first_key,b.second_key
from key_data_chufadi a
join key_word b
on a.question_desc like concat("%" ,b.first_key ,"%")
and a.question_desc like concat("%" ,b.first_key ,"%");
2.
SELECT a.*,b.first_word,b.second_word
from test1 a
join key_test b
on a.question_desc like '%' || b.first_word ||'%'
and a.question_desc like '%' || b.second_word || '%'
​
正确的写法是这样的，也没有好的回答，我的悬赏怎么办？百度好烂
select a.*,
concat(b.id,'-',b.first_key,'-',b.second_key) as contain_key_word
from key_data_ditu a
join key_word b
on a.question_desc like concat('%' ,b.first_key ,'%')
and a.question_desc like concat('%' ,b.second_key ,'%')
where a.create_time < '2017-04-17'
order by a.create_time

Answer 1

楼主应该这样写吧？
SELECT a.*,b.first_word,b.second_word
from test1 a
join key_test b
on a.question_desc like '%'+b.first_word +'%'
and a.question_desc like '%' +b.second_word + '%'