[RESOLVED] add 4 months on to all dates using just 1 query ?

[VisionsOfCody]

Hi

I'd like to add 4 months onto all dates in a filed called ' comm_date' in the table 'commandes' - the date format is 2006-12-20

can this be done with just 1 query ? ie

UPDATE commandes SET comm_date=(comm_date + 0000-04-00)

or something like that - and if the month number is on 12 then it needs to go to 04 ...

or do i need to do this line by line in php ?

thanks

[rulian]

UPDATE `commandes` SET `comm_date` = ADDDATE(`comm_date`, INTERVAL 4 MONTH) 

[VisionsOfCody]

that is just so cool and works prefectly - I learn something new every time i come here !!

thanks 🙂