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