CONCAT_WS() works as well, but the format is still the same. You still want to add your new data to your old data.
UPDATE tmpTable SET Textarea = CONCAT_WS(',',Textarea,'data you wish to add') WHERE ID = someID Just remember to make the delimiter something that you wouldn't normally see in a textfield so that you can differentiate between the new text and the old text. J.R. ---------------------------------------- From: sam rumaizan <[EMAIL PROTECTED]> Sent: Friday, April 06, 2007 12:31 PM To: [EMAIL PROTECTED] Subject: re: append information How About CONCAT_WS() "J.R. Bullington" <[EMAIL PROTECTED]> wrote: Use the CONCAT() function to achieve this: UPDATE tmpTable SET Textarea = concat(Textarea,'data you wish to add') WHERE ID = someID HTH! ---------------------------------------- From: sam rumaizan Sent: Thursday, April 05, 2007 12:23 PM To: mysql@lists.mysql.com Subject: append information I have a question if you don't mind. The update statement will replace the existing information. What if I have Textarea instead and I want to add information to the field without erasing previous information. Basically append information --------------------------------- Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. ---------------------------------------- Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta.