MONTHNAME

Syntax:
MONTHNAME(date)

Returns the full name of the month for date. The language used for the
name is controlled by the value of the lc_time_names system variable
(https://dev.mysql.com/doc/refman/8.0/en/locale-support.html).

URL: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html