SELECT in MYSQL grouped by month but showing all

1

I have the following table in MYSQL:

cavalo - 2016-01-15
cachorro - 2016-01-16
gato - 2016-02-23
coelho - 2016-02-24
ovelha - 2016-03-21
tatu - 2016-03-22

I wanted to give a SELECT and show it this way:

JANEIRO - 2016: cavalo cachorro

FEVEREIRO - 2016: gato coelho

MARÇO - 2016: ovelha tatu

I even tried with GROUP BY , but then he does not list all of each month, does anyone have a light?

    
asked by anonymous 29.01.2016 / 15:51

0 answers