如果存在,则编辑某个字段
update info_data_short_video_second set scene_pic = REPLACE(scene_pic,'192.168.10.18/group1','192.168.10.18:80/group1') where INSTR(scene_pic,'192.168.10.18/group1')> 0
如果存在,则编辑某个字段
update info_data_short_video_second set scene_pic = REPLACE(scene_pic,'192.168.10.18/group1','192.168.10.18:80/group1') where INSTR(scene_pic,'192.168.10.18/group1')> 0