https://dev.mysql.com/doc/refman/5.7/en/update.html

UPDATE some_table SET field1='Value 1' WHERE primary_key = 7

UPDATE `Table A`,`Table B`
SET `Table A`.`text`=concat_ws('',`Table A`.`text`,`Table B`.`B-num`," from ",`Table B`.`date`,'/')

UPDATE `table` SET `keywords` = concat_ws(', ',`keywords`,'main')

http://theory.phphtml.net/sql/concat_ws.html