DAYOFWEEK(date) returns the weekday index for date (1 = Sunday, 2 = Monday, ..., 7 = Saturday). : DAYOFWEEK « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. DAYOFWEEK

mysql>
mysql> SELECT DAYOFWEEK('1998-02-03');
+-------------------------+
| DAYOFWEEK('1998-02-03') |
+-------------------------+
|                       3 |
+-------------------------+
1 row in set (0.00 sec)

mysql>