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
, 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
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
, 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