From: Michael Dykman Date: February 9 2012 3:33pm Subject: Re: conditional updating List-Archive: http://lists.mysql.com/mysql/226771 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable He did mention that there was another field he was updating, which implies that the state of the date field was not the only condition. - michael On Thu, Feb 9, 2012 at 9:22 AM, Johnny Withers wrote= : > So, add your "other criteria" to the where clause, you failed to say > there were other conditions in your first email. > > Sent from my iPad > > On Feb 9, 2012, at 7:56 AM, william drescher wr= ote: > >> On 2/9/2012 8:22 AM, Johnny Withers wrote: >>> Update table set mydate=3Dnow() where mydate=3D'0000-00-00'; should do = it. >> can't do that because the record is selected by other criteria. >> Thanks >> >> bill >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql >> > > -- > 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.