SQLite 和自定义顺序

SQLite and custom order by(SQLite 和自定义顺序)

问题描述

我有一个带有类别的表格:

I have a table with categories:

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

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

Now I would like to order the result of the select statement to

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

例如.在 MySQL 中，你会这样做:

for example. In MySQL, you'd do it like this:

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

你会如何在 SQLite 中做到这一点?我没有order by"字段.

How would you do it in SQLite though? I don't have an "order by" field.

推荐答案

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

这篇关于SQLite 和自定义顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！