SQL SERVER
SELECT * FROM xxxx m WHERE m.isDel = 0
ORDER BY CHARINDEX( ',' + CONVERT ( varchar (10),m.type)+ ',' , ',2,1,3,' )
注意: 2,1,3 左右的逗号不能去掉
MYSQL
SELECT * FROM fruit
ORDER BY FIELD(name, 'Banana', 'Apple', 'Pear', 'Orange'), variety;