Monet wants to append something to the current value, so I think CONCAT() is
needed:
UPDATE temp
SET ReviewComments = CONCAT(ReviewComments, ', WHC')
WHERE ... ;
Michael
[EMAIL PROTECTED] wrote:
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 <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
