我有一个包含类别的表：
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 中你会怎么做呢？我没有“排序依据”字段。
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
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
