From: Johnny Withers (johnnypixelated.net)
Date: Thu Feb 09 2012 - 15:25:27 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <mdykmangmail.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 <johnnypixelated.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 <williamtechservsys.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
> - mdykmangmail.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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]