MySQL批量替换单字段数据

update content_type_center set field_center_url_value =  replace(field_center_url_value,'_https://portal.xxx.com','_http://www.yyy.com');