mysql group by day
snippet in sql

mysql group by day

user2564

GROUP BY DATE_FORMAT(record_date, '%Y%m')