Sam -- Please use REPLY-ALL when sending email to the list. Can you use \t? I don't think so. I know that if you want to enter in '\t', you will need to escape it '\\t', but MySQL may treat that as something else. It may treat it as a TAB in its own right, as I know that it will replace '\\r' with a Carriage Return in BLOB and TEXT fields. You should use something like pipe '|', brace '[', or bracket '{' and then use code to do a replace(). You should try it though, as I have not. It may work just fine, but your application code is really the way you want to do this. J.R. 1-Can I use Tab (\t) instead? 2- Can I insert the date this new data was added to the field?
"J.R. Bullington" <[EMAIL PROTECTED]> wrote: 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 Sent: Friday, April 06, 2007 12:31 PM To: [EMAIL PROTECTED] Subject: re: append information How About CONCAT_WS() "J.R. Bullington" 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. _____ Looking for earth-friendly autos? Browse <http://autos.yahoo.com/green_center/;_ylc=X3oDMTE4MGw4Z2hlBF9TAzk3MTA3MDc2B HNlYwNtYWlsdGFncwRzbGsDZ3JlZW5jZW50ZXI-> Top Cars by "Green Rating" at Yahoo! Autos' Green Center.