mysql 关联条件 中使用 like

select *from (select a.*,concat(b.id,'-',b.first_key,'-',b.second_key) as contain_key_word from key_data_0503 a  join key_word bon 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) tgroup by id