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