sql按照in里面的字段排序

ORDER BY field(要排序的字段,’in里面的参数1′,’in里面的参数2’···)

SELECT * FROM student_info s 
WHERE s.student_name in ('张三','李四','王五') 
ORDER BY field(student_name,'张三','李四','王五');