David-fethiye Posted January 12, 2009 Share Posted January 12, 2009 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 Quote Link to comment Share on other sites More sharing options...
ILMV Posted January 12, 2009 Share Posted January 12, 2009 Just use a new record for each entry? Quote Link to comment Share on other sites More sharing options...
trq Posted January 12, 2009 Share Posted January 12, 2009 UPDATE tbl SET fld = CONCAT(fld, 'new text'); Quote Link to comment Share on other sites More sharing options...
David-fethiye Posted January 12, 2009 Author Share Posted January 12, 2009 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.