I want to update a date field in a record. if the date in the
field is 0000-00-00 I want to change it to the current date. I
would appreciate suggestions or links on how to do this.

Yup, tried reading the manual, but need a bit of help.
I will be updating another field at the same time.

bill


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql