MONTHNAME()
MONTHNAME(date)
date
Returns the full name of the month for date. This code returns the string “July”:
SELECT MONTHNAME('2016-07-11');