mysql怎么查詢近一周的數(shù)據(jù)

select?*?from?table??where?DATE_SUB(CURDATE(),?INTERVAL?7?DAY)?<p><strong>拓展知識：</strong></p><p>查詢一天：</p><pre class="brush:sql;toolbar:false">select?*?from?table?where?to_days(column_time)?=?to_days(now()); select?*?from?table?where?date(column_time)?=?curdate();

select?*?from?table??where?DATE_SUB(CURDATE(),?INTERVAL?INTERVAL?1?MONTH)?<p><strong>示例如下：</strong></p><p>效果如圖（這里SQL語句中的一周范圍是指星期一到星期日，星期一為一周的第一天，因是8月11日查詢的，所以只顯示星期一到星期六的結(jié)果）：</p><p><img src="https://img.php.cn/upload/article/000/000/067/4a6065bdd3484473006f1ed12406b95d-0.png" alt="請?zhí)砑訄D片描述"></p><p>日歷：</p><p><img src="https://img.php.cn/upload/article/000/000/067/4a6065bdd3484473006f1ed12406b95d-1.png" alt="請?zhí)砑訄D片描述"></p><p>簡單來說就是用今天的日期生成前七天的日期（利用union all命令），并根據(jù)星期一的日期條件刷選出本周的日期</p><pre class="brush:php;toolbar:false">        SELECT  DATE(subdate(curdate(),date_format(curdate(),'%w')-1)) as thisweek           union all           SELECT  DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 1 day)) as thisweek           union all           SELECT  DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 2 day)) as thisweek           union all           SELECT  DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 3 day)) as thisweek           union all           SELECT  DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 4 day)) as thisweek           union all           SELECT DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 5 day)) as thisweek           union all           SELECT DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 6 day)) as thisweek

SELECT?DATE(subdate(curdate(),date_format(curdate(),’%w’)-1))