untested: update .... set mydate = IF(mydate = '0000-00-00', now(), mydate)
- michael dykman On Thu, Feb 9, 2012 at 8:14 AM, william drescher <will...@techservsys.com> wrote: > 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 > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql