From: Michael Dykman
Date: February 9 2012 1:18pm
Subject: Re: conditional updating
List-Archive: http://lists.mysql.com/mysql/226764
Message-Id: <CANLyif_vsGDGnc7HaEQKpqCp83BH_vSeG+p0uoBZ80JnVr=iQw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

untested:

update .... set mydate =3D IF(mydate =3D =A0'0000-00-00', now(), mydate)

 - michael dykman

On Thu, Feb 9, 2012 at 8:14 AM, william drescher
<william@stripped> 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. =A0I 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: =A0 =A0http://lists.mysql.com/mysql
>



--=20
=A0- michael dykman
=A0- mdykman@stripped

=A0May the Source be with you.