mysql 替换某字段的第7位字符

update table set num=CONCAT(replace(num,SUBSTR(num,7),4),SUBSTR(num,8)) where id=11;