conditional updating

[william drescher]

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