how to show Jan for January using MONTHNAME() mysql function code example

Example: mysql month name extract

SELECT MONTHNAME(column_date,’%m’)) as monthname from tablename;