mysql - SQL 设置 ORDER BY

Question

是否可以将 sql 语句中的 ORDER BY 设置为您想要的值？例如，如果我想按以下顺序选择 Day 的值:Thu, Sat, Sun, Mon

SELECT * 
FROM `NFL_Games` 
WHERE Week = '1' 
ORDER BY Day

Answer 1

您可以对个人订单使用 case when 子句...

order by
(case Day
 when 'Thu' then 1
 when 'Sat' then 2
 when 'Sun' then 3
 when 'Mon' then 4
 else 5 end), 
 Day