先查出被选择的,然后把为选择的拼在已选择的后面。
select * from (
select * from zn_org a where FIND_IN_SET(a.dwcode,'360728000201007001,360728000201027001')
UNION all
select * from zn_org b where !FIND_IN_SET(b.dwcode,'360728000201007001,360728000201027001')
) c
where 1=1