[Solved] I want get month() function return value as ‘jan’,feb etc

SELECT MONTHNAME(curdate());

Doc

or if you only need the first 3 letters

SELECT substr(MONTHNAME(curdate()), 1, 3);