Select with Mysql

[Anon]

Hi,
i have a table in mysql with a column that is a date format. There are 1400 records in this table, and i want to select and display the records from date1(05/05/2000) to date2(08/08/2001).

How can i do?

Thakns

[[deleted]]

SELECT *
FROM table
WHERE date_column < '2001-08-08'
AND date_column > '2000-05-05'

[Anon]

thanks