mysql daily posts count
by Prakash[ Edit ] 2013-08-03 12:56:15
To find how many posts are submitted daily on a month the following query can be used. In the following example I am getting the daily count of posts submitted on August 2013 :
select date,count(*) where month(date)=8 and year(date)=2013 group by day(date)
