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 va
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 Adm
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