[festiz]

SELECT date, COUNT(*) FROM table GROUP BY DATE_FORMAT(date, '%Y%m%d') ORDER by date 

%Y = 2004
%m = 07
%d = 18

Tror det ska fungera om jag uppfattat dig rätt.