Re: conditional updating

[Reindl Harald]

Am 09.02.2012 14:55, schrieb william drescher:
> 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.

so explain the criteria, show us the query

usually you do exatcly the same WHERE as for the select and add
and mydate='0000-00-00'


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc