how can i get all records from a db where there date field is one year ago

[deansaddigh]

How can i do the following code please if possible?

	//Automatically archive booking after one year of NOW()
$archivequery = "SELECT * FROM bookings WHERE date  is 1 year less than current date"
£queryresult =mysql_query($archivequery)

[Mchl]

WHERE `date` = CURDATE() - INTERVAL 1 YEAR

[deansaddigh]

Thanks very much.