对id进行排序,将指定的id排序在前面
SELECT
id
FROM
`sys_logs`
ORDER BY
CASE
WHEN ( id IN ( SELECT id FROM sys_logs WHERE id > 10 AND id < 15 ) ) THEN
对id进行排序,将指定的id排序在前面
SELECT
id
FROM
`sys_logs`
ORDER BY
CASE
WHEN ( id IN ( SELECT id FROM sys_logs WHERE id > 10 AND id < 15 ) ) THEN