[RESOLVED] changing date in database

[LordRogaine]

I'm using php with mysql database. I have a datetime field in one of my tables. If one of the fields contained this date 2006-11-14 00:47:14 what would the syntax be to alter this date in the database and add one day to it. I am not looking for (update table set field whatever to ='2006-11-15 00:47:14');

I want to be able to add one day increment to the existing date

Hope I made my thoughts clear on what I am looking for.

[NogDog]

UPDATE table_name SET date_col = DATE_ADD(date_col, INTERVAL 1 DAY)

Add a WHERE clause as applicable to specify which row(s) gets updated.

[LordRogaine]

That worked perfectly. Thanks!