Posted by xclarky on 02/05/06 16:31

I could have sworn I already replied to this but it appears that it did
not go through, but anyway; you want to modify the contents of an
existing field without having to fetch it using a query, yes? This is
possible through the use of MySQL's CONCAT() function:

UPDATE `my_table` SET `my_field` = CONACT(`my_field`, ' append this');

So, for example the value of 'my_field' is 'John'. Upon running the
query the value of 'my_field' will become 'John append this'. Hope that
helps.

[Back to original message]