I am trying to see what months are used in my table. I can get id and name (see below) no problem but I am having trouble pulling out the abrv. I have done it before using %b but can't seem to get the syntax right here. Where am I going wrong?

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

```

I want to return

```
    id  |name       |abrv
    1   |January    |Jan

```