mysql表字段中的字符串替换

将video表中id大于7的记录中的title字段中的字符串3.1替换为4.1

update video set title = replace(title,'3.1','4.1') where id >7

update sc_resource2 set url = replace(url,'http://xx.xx.xx.xx/localResource/public','http://xx.xx.xx.xx:81')