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.
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.
>> 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
May the Source be with you.