本文介绍了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 和自定义顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！