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
