1、order by id asc 按照id升序
eg: select id from users order by id asc
2、order by id desc 按照id降序
eg: select id from users order by id desc
3、order by field(name,'Suzi','Ben','Henry'); 按照name中 'Suzi','Ben','Henry'排序
MySQL可以通过field()函数自定义排序,格式:field(value,str1,str2,str3,str4),value与str1、str2、str3、str4比较,返回1、2、3、4,如遇到null或者不在列表中的数据则返回0
eg: select * from driver_log order by field(name,'Suzi','Ben','Henry');