我有一张带有类别的表：

ID  Category
"1","Baking"   
"3","Family"   
"4","Entertaining"   
"5","Children"   
"6","Desserts"

现在，我想将select语句的结果排序为

ID  Category
"4","Entertaining"   
"3","Family"  
"1","Baking"   
"5","Children"   
"6","Desserts"

例如。在MySQL中，您可以这样做：

SELECT * FROM CATEGORIES ORDER BY FIELD (ID, 4,3,1,5,6);

但是，您将如何在SQLite中做到这一点？我没有“订购依据”字段。