批量替换数据库某字段部分内容

update 表名 set 字段名=replace(字段名,’要替换的内容’,’替换后的内容’)


UPDATE NC_DownAddress


SET DownFileName = REPLACE(DownFileName, '',


'')


SELECT *


FROM NC_DownAddress


WHERE (DownFileName LIKE '%%')


update yonghuxinxi set yonghubianhao=replace(yonghubianhao,'——','-')


update yonghuxinxi set yonghubianhao=replace(yonghubianhao,'--','-')


wordpress主机