mysql按类别查询数据量

SELECT channel, count(*) from crawled_goods where datediff(created_at,NOW())=0 and channel like '%yijiupi%'
GROUP BY( channel)