Posted by Jim Michaels on 02/12/06 08:58

<xclarky@gmail.com> wrote in message
news:1139149880.794194.28780@o13g2000cwo.googlegroups.com...
>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');

you mean CONCAT

>
> 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]