1.根据cstate的4,5,7,1,2,3顺序排序
语句:
SELECT c.cstate,c.mc_1 from s_c c where c.cstate in(1,2,3,4,5,7) ORDER BY FIELD(c.cstate,4,5,7,1,2,3);
结果:
2.根据cstate的4,5,7,1,2,3和mc_1的3,2,1顺序排序
语句:
SELECT c.cstate,c.mc_1 from s_c c where c.cstate in(1,2,3,4,5,7) ORDER BY FIELD(c.cstate,4,5,7,1,2,3),FIELD(c.mc_1,3,2,1);
结果: