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: [email protected]
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.
