SQLite和自定义顺序 [英] SQLite and custom order by
本文介绍了SQLite和自定义顺序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个类别为
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中做到这一点?我没有订购依据"字段.
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和自定义顺序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文