select t.name,t.ats_id,a.id, a.name from tb_m t ,tb_u a
where concat(";",t.ats_id,";") REGEXP(concat(";",a.id,";"))
and a.id = 1111
order by t.id,a.id
前提的数据结构:
tb_m (id,name,ats_id)
tb_u(id,name)
ats_id = tb_u.id;tb_u.id;tb_u.id
select t.name,t.ats_id,a.id, a.name from tb_m t ,tb_u a
where concat(";",t.ats_id,";") REGEXP(concat(";",a.id,";"))
and a.id = 1111
order by t.id,a.id
前提的数据结构:
tb_m (id,name,ats_id)
tb_u(id,name)
ats_id = tb_u.id;tb_u.id;tb_u.id