update table[表名] set Fields[字段名]=replace(Fields[字段名],'被替换原容','要替换
成的内容')
如: admin@hcmcms
方法一:
update useraccount set userName = replace(userName,'@hcmcms','@aa');
方法二:
update useraccount set userName =replace(userName ,substring(userName,5,11),'@aa')
SQL 批量替换字符串
最新推荐文章于 2023-08-15 11:30:15 发布