WEEKDAY(date) different and returns the weekday index for the given date(0=Monday, 1=Tuesday, 2=Wednesday, and so on). : WEEKDAY « Date Time Functions « MySQL Tutorial

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

mysql>
mysql> SELECT DAYOFWEEK('0-2-1');
+--------------------+
| DAYOFWEEK('0-2-1') |
+--------------------+
|                  3 |
+--------------------+
1 row in set (0.00 sec)

mysql>