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'
signature.asc
Description: OpenPGP digital signature