我有一个表与类别：
ID Category "1","Baking" "3","Family" "4","Entertaining" "5","Children" "6","Desserts"
现在我想订购select语句的结果@H_403_4@
ID Category "4","Entertaining" "3","Family" "1","Baking" "5","Desserts"
SELECT * FROM CATEGORIES ORDER BY FIELD (ID,4,3,1,5,6);
ORDER BY
CASE ID
WHEN 4 THEN 0
WHEN 3 THEN 1
WHEN 1 THEN 2
WHEN 5 THEN 3
WHEN 6 THEN 4
END
