Selecting between two dates?

[xmatthawkx]

Hi Guys,

I have a single column in a table, which is in this format:

Y-m-d (ie. 2003-01-19)

I need to select data between two specified dates. For example, if date1 == 2002-04-10 and date2 == 2003-01-24, I need to return all the rows between those values.

Can anyone point me in the right direction?

Thanks very much!

[Mister]

Should work by doing the following:

$query = "SELECT * 
FROM tbl
WHERE date > date1
AND date < date2"

[xmatthawkx]

Thanks 🙂!

It seems to work pefectly...who would have thought it was so simple :p!

[Sxooter]

Note that you can also use the between keyword:

select * from database where date between 'firstdatehere' and 'seconddatahere';