Re: Subtracting months in MySQL
| From: | CPT John W. Holmes | Date: | Tue, 20 May 2003 13:48:30 +0000 |
| Subject: | Re: Subtracting months in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27921@lists.php.net to get a copy of this message | ||
> I have a table that stores a daily summary of page hits. I need to be able
> to summarize this data by month, which I've done with the following query:
>
> SELECT
> MONTHNAME(date) as month,
> YEAR(date) as year,
> SUM(count) as count
> FROM pagehits
WHERE date > CURDATE() - INTERVAL 12 MONTH
> GROUP BY
> YEAR(date),
> MONTHNAME(date)
> ORDER BY
> YEAR(date),
> MONTH(date)
>
> I then need to limit this to the previous 12 months.
---John Holmes...