Select statement between two dates MySq

[Anon]

Hi
Any one can you help me query data between two dates(ie two date fields)

Thanks
Ramarao

[nobbie]

Hi,

This should work:

SELECT * FROM tablename WHERE datefield BETWEEN '01012002' AND '02022002'