MySQL: How to select records for this week? May 30, 2023 by Tarik Use YEARWEEK(): SELECT * FROM your_table WHERE YEARWEEK(`date`, 1) = YEARWEEK(CURDATE(), 1)