MySQL MONTH Clause: Want to get Month Name instead of number
SELECT MONTHNAME('2018-11-03');


... should give 'November'. So use MONTHNAME instead of MONTH.

Another option is the DATE_FORMAT function. This should give the same result as above:

SELECT DATE_FORMAT('2018-11-03', '%M');


Use %b instead of %M to get abbreviated month names (Jan, Feb etc).