Yes, UPDATE ... SET... is exactly what you would use. Just set the column
to be the combined value of the two values.
Please read: http://dev.mysql.com/doc/mysql/en/UPDATE.html
UPDATE tablename
SET fieldname = 'new list of values that you wanted'
WHERE _where_conditions_
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Monet <monet_lee@stripped> wrote on 08/24/2004 07:49:37 PM:
> Hi all,
>
> I though it is impossible to do that but I like check
> with you guys in case it is just because I never heard
> it.
> I have a table with a text column. Is there any way I
> can append some word into this field when I update the
> table?
> For instance,
> Table temp, column ReviewComments, data type of
> ReviewComments is varchar.
> Value in “ReviewComments” is “PSRC”.
> After update, value in “ReviewComments” should be
> “PSRC, WHC”
>
> Can I do that by using UPDATE … SET ….
>
> Thanks a lot.
>
> Monet
>
>
>
>
> _______________________________
> Do you Yahoo!?
> Win 1 of 4,000 free domain names from Yahoo! Enter now.
> http://promotions.yahoo.com/goldrush
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1reen@stripped
>