Appending to an existing table record?

jeddi · 01-12-2009, 09:44 AM

Hello,

I am writing a simple "mini-blog" for my website. I don't want all the works of a wordpress or other program so I am just using a text area to update one of the fields in my table.

Is there a way to simply add extra data on the end of a mysql table record without reading the exiesting data into a variable, appending the new info and then UPDATE'ing the record ?

Thanks for any info

abduraooft · 01-12-2009, 11:09 AM

Code:

update table_name set filed_name=concat(filed_name,'new string') where...

jeddi · 01-12-2009, 02:36 PM

Yes - thats it !

I have been reading about concat() but couldn't see how to use it !

So UPDATE tbl SET fld = CONCAT(fld, 'new text'); should do the business

Thanks