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