mySQL ORDER BY DAYOFWEEK 从今天开始

Question

我有一个每周不同日期发生的事件列表。我希望我的查询返回从今天开始按星期几排序的结果。

'Meeting_Day' = Sunday,  Monday, Tuesday...
'Day_of_Week' = 1, 2, 3...

SELECT Meeting_Day, Day_of_Week, 
    Day_of_Week + (Day_of_Week - DAYOFWEEK(NOW())) as x FROM `meetings` ORDER BY x

这对于专业人士来说可能很简单，但我不是专业人士。

Answer 1

我又仔细看了看，发现这样就可以了。

SELECT 
  *, 
  If(Day_of_Week < DAYOFWEEK(Now()), (Day_of_Week + 7), Day_of_Week) as SDAY 
FROM `meetings` 
ORDER BY SDAY