mysql field自定义排序函数
order by field(value,str1,str2,str3..)
参数说明 value为字段名,后面参数为指定要排序的字段值
eg: 按字段degree学历大小排序
select * from education_info where school='北京大学' order by field(degree,'博士','硕士','学士','') asc
注:如果表中有数据为NULL,并且要将其排到最后可以做如下修改
select * from education_info where school='北京大学' order by degree is null asc, field(degree,'博士','硕士','学士','') asc