UPDATE 数据库名 SET 字段名 = REPLACE(字段名 ,查找的需要被替换的字符串,最终替换成的字符串);将谷歌网址替换成百度网址:
UPDATA tablename SET field = REPLACE(field,'https://www.google.com','https://www.baidu.com');
将谷歌网址去掉:
UPDATA tablename SET field = REPLACE(field,'https://www.google.com','');