mysql字段A复制到字段B,并替换指定字符

update `table` set 字段b=replace(字段b,'3366',字段a);

eg:update `hy_b_pro` set goldWeight=jinJinZhong;