[MYSQL] 날짜로 group by

/* '%Y%m%d' 혹은 '%Y-%m-%d' */
select
    date_format(articleregdt, '%Y%m%d') as date,
    count(*)
from article
group by date_format(articleregdt, '%Y%m%d')
order by date asc