胡姐姐的博客

原创 mysql根据多个字段按照固定顺序排序

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.cstat...