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

Here is my attempt:

UPDATE users SET IFNULL(box1 = NOW()), box2 = NOW() WHERE eMail =

Any help would be greatly appreciated.

Using:  MySQL 3.22.27

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to