使用CONCAT()函数

mysql向表中某字段后追加一段字符串（field为字段名）:

update table_name set field=CONCAT(field,’str’,)

mysql 向表中某字段前加字符串
update table_name set field=CONCAT(‘str’,field)
本人示例:

update rockphp_live_kj set content=concat('<video controls="controls" width="320" height="240"> <span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><source src="http://xxx.xxx.com',content,'" type="video/mp4" /><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_end"></span> <source src="movie.ogg" type="video/ogg" /> 您的浏览器不支持 video 标签。</video>');