How can I do this in one query? I want to generate a results set like
today 0
30-day 5
60-day 18
I would like to extract this in a single statement. I'm currently doing it in 3 queries like this:
mysql> select count(me_id) from messages where to_days(me_date)>to_days(now())-7;
+--------------+
| count(me_id) |
+--------------+
| 1 |
+--------------+
1 row in set (0.00 sec)
mysql> select count(me_id) from messages where to_days(me_date)>to_days(now())-30;
+--------------+
| count(me_id) |
+--------------+
| 5 |
+--------------+
1 row in set (0.00 sec)
mysql> select count(me_id) from messages where to_days(me_date)>to_days(now())-60;
+--------------+
| count(me_id) |
+--------------+
| 18 |
+--------------+
1 row in set (0.00 sec)