MySQL Tutorial/Date Time Functions/WEEKOFYEAR
WEEKOFYEAR(date) returns the calendar week of the date as a number in the range from 1 to 53.
<source lang="sql">
mysql> mysql> SELECT WEEKOFYEAR("1998-02-20"); +--------------------------+ | WEEKOFYEAR("1998-02-20") | +--------------------------+ | 8 | +--------------------------+ 1 row in set (0.00 sec)</source>