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