语句:
方法一:
select * from card where datediff(now(),date)<7
and (dayofweek(now())-dayofweek(date))>0;
datediff先求出两个日期相差的天数,dayofweek求出两个日期的星期差
方法二:
select * from card
where yearweek(date_format(date,'%Y_%m_%d'))=yearweek(now());
yearweek获取年份和周数,%Y_%m_%d大小写有区别