Date SQL Query

[MuraliDharan V]

mysql> SELECT * FROM test_date;
+----+---------------------+---------------------+--------+
| id | from_date | to_date | status |
+----+---------------------+---------------------+--------+
| 1 | 1999-01-01 00:00:00 | 2000-01-01 00:00:00 | 1 |
| 2 | 2000-02-01 00:00:00 | 2002-01-01 00:00:00 | 1 |
| 3 | 2003-02-01 00:00:00 | 2005-01-01 00:00:00 | 1 |
+----+---------------------+---------------------+--------+
3 rows in set (0.01 sec)


This is my table, If my input is '2001-01-01', then i need to retrieve two records (id=1 and id=2) from my table.

How can i get it in a SQL Query.

Thanks,
Murali.V