select dates from to

[helenp]

Hi,
I donīt know if to post here or where else.

I Need to select from 1 table mysql dates that are between for example 2004-09-01 and 2004-09-30 canīt find out how to do it.
Thanks

[killroy]

SELECT *
FROM table
WHERE date BETWEEN "2004-12-24" AND "2005-01-01"

That'll select between christmas and newyear ;)

SN