It implied to me there were two fields to update based on the date
being a given value. Read it how you like.
Sent from my iPad
On Feb 9, 2012, at 9:34 AM, Michael Dykman <mdykman@stripped> wrote:
> 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 <johnny@stripped> 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 <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
>>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql
>>
>
>
>
> --
> - michael dykman
> - mdykman@stripped
>
> May the Source be with you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
