MySQL按月和年过滤结果

只需使用MONTH（）和YEAR（）函数

SELECt COUNT(*) as `count`,      `region`,        YEAR(`date`) as `year`,       MonTH(`date`)  as `month`   FROM my_stores.stats         WHERe  YEAR(`date`) in (2012,2013) GROUP BY `region`, YEAR(`date`),MonTH(`date`)