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?