mysql替换字段中部分字符串

转：

UPDATE invoice SET pdf_Url= replace(pdf_Url, 'http', 'https') WHERE fpqqlsh = 10101000011006117457;

UPDATE invoice SET pdf_Url= replace(pdf_Url, 'http://', 'https://') WHERE fpqqlsh = 10101000011006117457;

mysql替换字段中部分字符串

解决：使用replace(obj, search, replace_str)函数;

sql语法： UPDATE 表名 SET 字段名=replace(字段名, ‘被替换字符串’, '用来替换的字符串') ;

sql： UPDATE `member` SET `phone`=replace(`phone`, ''', '') ;

update item as t set 
t.share_descs=REPLACE(t.share_descs,'罗莱LOVO','LOVO')
 WHERE t.theme = '2c9280856efd0b23016efdacb45c0444'