Sql:
UPDATE t_door_control SET comm_info = REPLACE(字段名,'被替换字符串的部分','替换内容')
eg:
UPDATE t_door_control SET comm_info = REPLACE(comm_info,'172.16.3.10','10.45.157.79')
Sql:
UPDATE t_door_control SET comm_info = REPLACE(字段名,'被替换字符串的部分','替换内容')
eg:
UPDATE t_door_control SET comm_info = REPLACE(comm_info,'172.16.3.10','10.45.157.79')