‘zhangsan.cn’->'zhangsan.com' var str='zhangsan.cn'; update Table set Domain=REPLACE(str,'.cn','.com'')