joined:Feb 22, 2003
Greetings to the forum
I seem to be having a problems again with basic SQL :(
Here is what I am trying to do:
SET column1 = 'value1'
WHERE column2 = 'value1'
AND column1 = '';
I am trying to update column1 with the same value that is in column2 if and only when column1 is empty or NULL.