Re: Help with an UPDATE query please
| From: | John W. Holmes | Date: | Thu, 05 Feb 2004 12:53:52 +0000 |
| Subject: | Re: Help with an UPDATE query please | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32803@lists.php.net to get a copy of this message | ||
> > I have (among others) two DATE columns in a table; Booking_Date and
> > Booking_Completion_Date. How can I run a query that updates
> > Booking_Completion_Date to be 2 days after Booking_Date where
> > Booking_Completion_Date is NULL?
UPDATE table SET Booking_Completion_Date = Booking_Date + INTERVAL 2 DAY
WHERE Booking_Completion_Date IS NULL;
---John Holmes...