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 <mdyk...@gmail.com> 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 <joh...@pixelated.net> 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 <will...@techservsys.com> 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
>  - mdyk...@gmail.com
>
>  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
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to