我想让month（）函数返回值为'jan'，feb等

Question

I want output of Mysql Month() function as 'Jan',Feb etc.

Answer 1

SELECT MONTHNAME(curdate());

Doc

or if you only need the first 3 letters

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