DAYNAME(date) returns the name of the weekday for date : DAYNAME « Date Time Functions « MySQL Tutorial

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

The language used for the name is controlled by the value of the lc_time_names system variable.

mysql>
mysql> SELECT DAYNAME('1998-02-05');
+-----------------------+
| DAYNAME('1998-02-05') |
+-----------------------+
| Thursday              |
+-----------------------+
1 row in set (0.00 sec)