MySQL replace()字符串替换函数的使用

replace函数定义

replace(original-string，search-string，replace-string)

把ability_info表中所有path字段里的'172.18.223.226'字符串替换成'222.86.208.111'

update 
	`ability_info` 
set 
	path=replace(path,'172.18.223.226','222.86.208.111')