This article is tagged with:
This week mysql
and mysql
mysql date of the week
DAYOFWEEK(date)
this week mysql
SELECT *
FROM your_table
WHERE YEARWEEK(`date`, 1) = YEARWEEK(CURDATE(), 1)