List:General Discussion« Previous MessageNext Message »
From:william drescher Date:February 9 2012 1:55pm
Subject:Re: conditional updating
View as plain text  
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


Thread
conditional updatingwilliam drescher9 Feb
  • Re: conditional updatingMichael Dykman9 Feb
    • Re: conditional updatingwilliam drescher9 Feb
  • Re: conditional updatingJohnny Withers9 Feb
    • Re: conditional updatingwilliam drescher9 Feb
      • Re: conditional updatingReindl Harald9 Feb
        • Re: conditional updatingwilliam drescher11 Feb
      • Re: conditional updatingJohnny Withers9 Feb
        • Re: conditional updatingMichael Dykman9 Feb
          • Re: conditional updatingJohnny Withers9 Feb