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 > > > > > _______________________________ > 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/[EMAIL PROTECTED] >
