Mega Code Archive
DAYOFWEEK(date) returns the weekday index for date (1 = Sunday, 2 = Monday, , 7 = Saturday)
mysql>
mysql> SELECT DAYOFWEEK('1998-02-03');
+-------------------------+
| DAYOFWEEK('1998-02-03') |
+-------------------------+
| 3 |
+-------------------------+
1 row in set (0.00 sec)
mysql>