UPDATE queries to expand upon, not replace, the existing value

[callumd]

Hi,

I'd like to run an update query that doesn't replace the existing value in the database, but rather, simply adds the new value on the end of the existing one.

Can this be done?

[NogDog]

Yes. In MySQL, you would use the concat() function:

UPDATE `table` SET `column` = CONCAT(`column`, ' additional text');

[callumd]

Excellent, thanks.