RE: month by month count

2003-08-20 Thread Jeff McKeon
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

Re: month by month count

2003-08-19 Thread Terence
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 Subject: month by month count I need to generate