sql按照非数字排序

在mysql中我们使用order by来实现查询排序，

但是我们如果想要排序的字段为中文时，这时候按照上面的方式排序就无效了，这时候我们需要将该字段转化成GBK编码进行排序

SELECT * FROM member ORDER BY CONVERT(username USING 'GBK') ASC //查询用户表并按照用户名正序排序
SELECT * FROM member ORDER BY CONVERT(username USING 'GBK') DESC //查询用户表并按照用户名倒序排序

或者

 

SELECT `ID` FROM wp_posts WHERE `ID` in (1,2,3,4,5) ORDER BY FIELD(`ID`,5,4,3,1,2); 

SELECT `ID` FROM wp_posts WHERE `ID` in (1,2,3,4,5) ORDER BY FIND_IN_SET(`post_title`,'A,B,C,D,E');