mysql query: concatenating onto an existing field
 

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

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

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

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

thx :cheeky:

you're welcome Jake :)