SQL语句备忘
1.替换某个字段中的字符
字段需要时varchar格式的,不是的话请先进行转换。
UPDATE `yb_mv` set `image`=REPLACE(CASE(`image` AS varchar(8000)),'192.168.1.200','192.168.0.200')
UPDATE `yb_mv` set `image`=REPLACE(`image`,'192.168.0.200','192.168.1.200')
UPDATE `yb_mv` set `image`=REPLACE(CASE(`image` AS varchar(8000)),'192.168.1.200','192.168.0.200')
UPDATE `yb_mv` set `image`=REPLACE(`image`,'192.168.0.200','192.168.1.200')