mysql获取本周

SELECT DATE_SUB(CURDATE(), INTERVAL DAYOFWEEK(CURDATE()) - 2 DAY) AS '本周一';

SELECT DATE_ADD('2023-01-01', INTERVAL n DAY) AS 'date'
FROM (
    SELECT @rownum:=@rownum+1 AS n
    FROM (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) t1,
         (SELECT @rownum:=0) t2
) t3
WHERE DATE_ADD('2023-01-01', INTERVAL n DAY) BETWEEN DATE_SUB(CURDATE(), INTERVAL DAYOFWEEK(CURDATE()) - 2 DAY) AND CURDATE();

SELECT *
FROM logs
WHERE log_date BETWEEN DATE_SUB(CURDATE(), INTERVAL DAYOFWEEK(CURDATE()) - 2 DAY) AND CURDATE();