1. 测试表数据
2. 自定义 asc升序排列(order by 列名 asc/desc )默认情况是asc升序排列
SELECT *,FIELD(a.state,'A','B','c') yy FROM cs a ORDER BY FIELD(a.state,'A','B','c') ASC
3. 自定义 desc降序排列
SELECT *,FIELD(a.state,'A','B','c') yy FROM cs a ORDER BY FIELD(a.state,'A','B','c') DESC