MySql 两张表联合查询时一个字段在另一张表中模糊匹配

stackoverflow

select tasks.name 
from users left join tasks on users.specialty LIKE CONCAT('%',tasks.tags,'%') 
where users.username = 'JinkX'

select tasks.name 
from users left join tasks on users.specialty REGEXP CONCAT('(^|,) ?',tasks.tags,' ?($|,)') 
where users.username = 'JinkX'

FIND_IN_SET(task.tags,users.specialty)