select * from 表
order by case name when 'aaa1' then 1
when 'bb4' then 2
when 'bbb3' then 3
when 'aaa2' then 4
else 5 end,name asc
order by case name when 'aaa1' then 1
when 'bb4' then 2
when 'bbb3' then 3
when 'aaa2' then 4
else 5 end,name asc
调试欢乐多
可在表中加一列,这200个赋值0,其他赋值1
然后
...order by 该列