select * from table t ORDER BY field(t.pass_flag,'1','0','2','-1','3')
(t.pass_flag,'1','0','2','-1','3')中t.pass_flag是字段,后面是排的顺序
select * from table t ORDER BY field(t.pass_flag,'1','0','2','-1','3')
(t.pass_flag,'1','0','2','-1','3')中t.pass_flag是字段,后面是排的顺序