mysql daily posts count

by Prakash 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)

Tagged in:

441
like
0
dislike
0
mail
flag

You must LOGIN to add comments