[wplug] OT: Any MySQL gurus? Quick easy question..

[techmike]

Perfect!

I was kind of close I guess with my second effort..  I tried AND, but I
left out the column name and the less-than-or-equal-to on the second
half..  heh

Thanks!
-Mike

-----Original Message-----
From: Robert Dale <robdale at gmail.com>
To: General user list <wplug at wplug.org>
Date: Wed, 28 Jul 2004 12:44:27 -0400
Subject: Re: [wplug] OT: Any MySQL gurus? Quick easy question..

> On Wed, 28 Jul 2004 12:28:39 -0400, techmike <mikeslists at access995.com>
> wrote:
> > How would I do this same query but return a month worth of rows?  I
> tried
> > adding LIMIT 31, but no such luck..
> > 
> > SELECT *
> >     FROM my_table
> >     WHERE date = "03-01-04"
> >     ORDER by date
> 
> in code, figure out the month's first and last day.
> put those dates in the statement fragment below:
> WHERE date >= "03-01-04" AND date <= "03-31-04"
> 
> (assuming MM-DD-YY format)
> 
> -- 
> Robert Dale
> _______________________________________________
> wplug mailing list
> wplug at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug