SQL自定义排序

SELECT * FROM tbl ORDER BY FIELD(type,5,1,2,3,4) ASC

没有在FIELD中定义的值asc时会排在最上边