SQLite和自定义顺序

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

现在我想订购select语句的结果

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

例如。在MySQL中，你会这样做：

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

你会怎么做在SQLite虽然？我没有“order by”字段。

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!