1:16 AM
> To: Scott Haneda; MySql
> Subject: Re: month by month count
>
>
> select count(*), monthname(yourfield)
> from yourtable
> where year = '2003'
> group by monthname(yourfield)
>
> - Original Message -
> From: "Scott Haneda&q
select count(*), monthname(yourfield)
from yourtable
where year = '2003'
group by monthname(yourfield)
- Original Message -
From: "Scott Haneda" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 12:38 PM
I need to generate record counts for each month in a year, just one year at
a time, but a full year at a glance.
I am thinking 12 hits to the DB is perhaps not the most idea way to do it,
is there a way to rip this out in one go?
--
-
Sc
