Need help with a SQL statement

[chrislynch8]

Hi,

THis is want I want to acheive - I want to search on a date field where all values are more then 1 day ago and to then update all those value by one year.

How do I use a SQL select to select all the correct date I need?

Rgds
Chris

[davidboris]

Hello,

Something like,

UPDATE tablename SET field_name = DATE_ADD(field_name,INTERVAL 1 YEAR) WHERE field_name < CURDATE();