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