mysql 周 获取日期范围,mysql - Mysql列表日期范围之间的日期，但仅限于一周中的特定日期 - SO中文参考 - www.soinside.com...

使用星期一开始的函数WEEKDAY()来计算它。

e.g：

where WEEKDAY(DAY) = 'Monday';

超过一天使用in关键字：

where WEEKDAY(DAY) in ('Monday', 'Tuesday','Friday');

当你使用别名时，你必须使用而不是在哪里：

having WEEKDAY(DAY) in ('Monday', 'Wednesday');

最终查询：

SELECT ADDDATE('2018-03-01', INTERVAL @i:=@i+1 DAY) AS DAY

FROM (

SELECT a.a

FROM (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS a

CROSS JOIN (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS b

CROSS JOIN (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS c

) a

JOIN (SELECT @i := -1) r1

WHERE

@i < DATEDIFF('2018-03-20', '2018-03-01') having WEEKDAY(DAY) in

('Monday', 'Wednesday');