MYSQL select between dates

[listenmirndt]

Fields "DAY", "MONTH", "YEAR" in table.

Date formatted as "01", "01", "2000"

I would like to select between a date range,

Not too sure how to do this.

Thanks

[dagon]

use a date field

[Weedpacket]

And post in the correct forum.

[bradgrafelman]

Once you switch to using a DATE column (which you should, since that's the correct column type based on the data), look into using the BETWEEN operator (assuming your DBMS is MySQL).

[Toadums]

http://www.phpbuilder.com/board/showthread.php?t=10366103 look like a few posts down