mysql weeknum code example
Example 1: this week mysql
SELECT *
FROM your_table
WHERE YEARWEEK(`date`, 1) = YEARWEEK(CURDATE(), 1)
Example 2: mysql date of the week
DAYOFWEEK(date)
SELECT *
FROM your_table
WHERE YEARWEEK(`date`, 1) = YEARWEEK(CURDATE(), 1)
DAYOFWEEK(date)