mysql query: concatenating onto an existing field

[Jakeman]

Lets say I have the field table.field of type mediumtext that already contains a string value. I want to add to the value of the field by concatenating another string on the end of the existing string.

Is there a special query to do this or do I need to concatenate in PHP and then do a regular UPDATE query?

thx

[Dean C]

I think you can use the MySQL function CONCAT. Straight from the manual:

http://dev.mysql.com/doc/mysql/en/String_functions.html

[Xenon]

so in short:
[sql]UPDATE table SET field = CONCAT(field, 'additional string')[/sql]

[Jakeman]

thx :cheeky:

[Xenon]

you're welcome Jake