Re: conditional updating

[Johnny Withers]

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 <william@stripped> wrote:

> On 2/9/2012 8:22 AM, Johnny Withers wrote:
>> Update table set mydate=now() where mydate='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:    http://lists.mysql.com/mysql
>