mysql从表中选择不同的月份(缩写)

Question

我想看看我的表中使用了哪些月份。我可以获得 id 和名称(见下文)没问题，但我无法提取 abrv。我在使用 %b 之前已经完成了，但似乎无法在此处获得语法。我哪里错了？

    SELECT DISTINCT 
    MONTH(date) as id, 
    MONTHNAME(date) as name, 
    MONTHNAME(date, '%b') as abrv
    FROM table_name ORDER BY id ASC

我想回去

    id  |name       |abrv
    1   |January    |Jan

Answer 1

我会这样做:

    SELECT DISTINCT 
    MONTH(date) as id, 
    MONTHNAME(date) as name, 
    SUBSTRING(MONTHNAME(date),1,3) as abrv
    FROM table_name ORDER BY id ASC