MONTHNAME()

MONTHNAME(date)

Devuelve el nombre del mes para la fecha date:

mysql> SELECT MONTHNAME('1998-02-05');
+-------------------------+
| MONTHNAME('1998-02-05') |
+-------------------------+
| February                |
+-------------------------+
1 row in set (0.03 sec)