Getting Rows between dates

[Arc]

Hey guys.

I have a date field (DateAdded) in my database (mySQL) and I need to get all rows from the table where DateAdded <= 2 years from DateAdded.

In other words, I don't want to show any of the rows where Today is greater than DateAdded + 2 years.

Is it possible to do that in a single SQL satement?

Something like: $sql="SELECT * FROM tblAccountInfo WHERE DateAdded <= DateAdded + 2 Years";

Or

Something like: $sql="SELECT * FROM tblAccountInfo WHERE Today is less than 2 years from DateAdded";

Thanks guys! You rock!

[devinemke]

SELECT * FROM tblAccountInfo WHERE DateAdded BETWEEN DATE_SUB(CURDATE(), INTERVAL 2 YEAR) AND CURDATE()