> > 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...

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to