var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: newbie Update question
forgive the rookie nature of this question...
trying to do an update for values in a text column to append additional text string to each value, but obviously am not using the concatenation operator ( || ) correctly. here is what i tried:
UPDATE table SET columnName = columnName || ' added string ' WHERE id = XX
the result i get is that the matched columnName is reset to 0.
thanks for any help,
instead of '||', try,
CONCAT(columnName, ' added string ')
just got around to this again and want to thank you for your post. worked perfectly!