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 Link to comment https://forums.phpfreaks.com/topic/140478-solved-appending-to-an-existing-table-record/ 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? Link to comment https://forums.phpfreaks.com/topic/140478-solved-appending-to-an-existing-table-record/#findComment-735134 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'); Link to comment https://forums.phpfreaks.com/topic/140478-solved-appending-to-an-existing-table-record/#findComment-735141 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 Link to comment https://forums.phpfreaks.com/topic/140478-solved-appending-to-an-existing-table-record/#findComment-735274 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.