update tablename set Columnname = Columnname + 'newstring' where id = X
So if you are say updating a column that is a URL and you want all instances in the table to receive a new value at the end of the URL, your query might look like:
update url_table set urlfield = urlfield + '&additionalfield=true'
1 comments:
Thanks
Post a Comment