sql - 按 ... IN(...) ASC 排序

Question

我想首先获取特定位置的所有配置文件:

SELECT * FROM profile
WHERE location IN ('a', 'b', 'c') OR isDefault=1 
ORDER BY location IN ('a', 'b') DESC, -- put to the front if location in 'a','b'
         isDefault DESC,              -- for each of both groups, put default profiles before the others.
         location ASC                 -- and sort each of the up to four groups by location.

这会引发错误:“关键字‘IN’附近的语法不正确。”。如果我删除 order 子句，则会返回结果。

这里出了什么问题？

Answer 1

您可以重写它以返回可排序的整数:

case when location IN ('a', 'b') then 0 else 1 end DESC