UPDATE IF
| From: | Gary | Date: | Mon, 14 Mar 2011 15:42:46 +0000 |
| Subject: | UPDATE IF | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47720@lists.php.net to get a copy of this message | ||
I have a table in a mysql db that has 3 columns that I want to insert
(update) data if the row&column is empty (IS NULL). However I want to start
at the first column, if this column is not null, then move to insert the
data into column 2, if that is empty, then insert data into column 3.
I have been looking over the manual and boards but am not finding a
solution.
Can anyone point me in the right direction.
--
Gary
__________ Information from ESET Smart Security, version of virus signature database 5952 (20110314)
__________
The message was checked by ESET Smart Security.
http://www.eset.com