直接上脚本:
SELECT p.id,p.code ,if(FIND_IN_SET(p.`code`,pl.codelist),'是','否') AS tag , pl.codelist from person p LEFT JOIN person_list pl ON
FIND_IN_SET(p.code,pl.codelist)
表person:
表person_list:
查询结果:
直接上脚本:
SELECT p.id,p.code ,if(FIND_IN_SET(p.`code`,pl.codelist),'是','否') AS tag , pl.codelist from person p LEFT JOIN person_list pl ON
FIND_IN_SET(p.code,pl.codelist)
表person:
表person_list:
查询结果: