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

[Robert Dale]

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