mysql可以通过field()函数自定义排序，格式：field(value,str1,str2,str3,str4)，value与str1、str2、str3、str4比较，返回1、2、3、4，如遇到null或者不在列表中的数据则返回0.
mysql> select * from driver_log order by field(name,'suzi','ben','henry');
+--------+-------+------------+-------+
| rec_id | name  | trav_date  | miles |
+--------+-------+------------+-------+
|      2 | suzi  | 2006-08-29 |   391 |
|      7 | suzi  | 2006-09-02 |   502 |
|      1 | ben   | 2006-08-30 |   152 |
|      9 | ben   | 2006-09-02 |    79 |
|      5 | ben   | 2006-08-29 |   131 |
|      8 | henry | 2006-09-01 |   197 |
|      6 | henry | 2006-08-26 |   115 |
|      4 | henry | 2006-08-27 |    96 |
|      3 | henry | 2006-08-29 |   300 |
|     10 | henry | 2006-08-30 |   203 |
+--------+-------+------------+-------+