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
