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

• Next in forum: Re: Reading from file
• Prev in forum: Re: Using an image as a link
• Thread view: Re: Quickly adding text to a mysql text field that is NOT empty

[Reply to this message]