SELECT, DATE

[Anon]

Hi All I was wondering is there a way to select a range of dates for a mysql DB

i.e Say all record From Feb 2 2001 to May 20 2002

TIA
RichieTM

[Anon]

Never mind the question below is what I was asking thank any

[olechka]

select * from table_name where date_field > 2000-02-12 and date_field < 2002-05-05

This should work