help MySQL with query

[Anon]

2001-10-18 18:57:23
2001-10-18 18:58:31
2001-10-18 19:49:55
2001-10-19 16:53:33
2001-10-19 16:55:20

I want to output the following:

2001-10-18=3
2001-10-19=2

Thank you very much

[[deleted]]

Read the MySQL manual about GROUP BY

[Anon]

i´ve read it, is there any way to group by DATE a DATETIME column?

[[deleted]]

yes there is, but be carefull what exactly you group by.

Check out the date and time functions in the MySQL manual, and play around with them on the commandline.

[Anon]

THANKS, i am playing with DATE_FORMAT and seems to work fine.

Regards

Pepe