mysql 表字段部分替换

update user set `ph` = REPLACE(`ph`,'shenji.osnt.me','60.210.113.147:555');