Hello, I am new to SQL so I hope this is not a lame question. I want to UPDATE two fields ('box1' & 'box2') in table 'users'. One field I want to always set the current time. The other field I want to put the current time ONLY if it has the value NULL.
Here is my attempt: UPDATE users SET IFNULL(box1 = NOW()), box2 = NOW() WHERE eMail = '[EMAIL PROTECTED]' Any help would be greatly appreciated. Jane. Using: MySQL 3.22.27 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php