UPDATE 表名 SET 字段=REPLACE(字段名,'被替换内容','要替换成的内容')
例如:
use hctv_15; 库
use hc_application; 表
update hc_application set icon_focus = replace(icon_focus,'192.168.1.2','localhost') where icon_focus like '%192.168.1.2%'
update hc_application set icon_focus = replace(icon_focus,'192.168.1.2','localhost'),
icon = replace(icon,'192.168.1.2','localhost')
转载于:https://blog.51cto.com/shicg6/718039