mysql - 如何获得一个月内的所有星期一？

Question

我想获取 2015 年 5 月的所有星期一

(使用mysql查询)

输出:

MON   
04  
11  
18  
25

Answer 1

select row+1  as Mon from   
( SELECT @row := @row + 1 as row FROM
  (select 0 union all select 1 union all select 3 union all select 4 union all select 5 union all select 6) t1,
  (select 0 union all select 1 union all select 3 union all select 4 union all select 5 union all select 6) t2,
  (SELECT @row:=-1) t3 limit 31 ) b where
         DATE_ADD('2015-05-01', INTERVAL ROW DAY) between '2015-05-01' and '2015-05-31' and DAYOFWEEK(DATE_ADD('2015-05-01', INTERVAL ROW DAY))=2;

输出

+------------+
| Mon        |
+------------+
|          4 |
|         11 |
|         18 |
|         25 |
+------------+

稍微调整一下 query