mysql 替换某字段内容
替换图片域名
UPDATE `mallProductImage` SET `image` = replace (`image`,'yjike.com','maxcx.net') WHERE id>0;
UPDATE `mallProduct` SET `image` = replace (`image`,'yjike.com','maxcx.net') WHERE id>0;
UPDATE `mallProductDescription` SET `content` = replace (`content`,'yjike.com','maxcx.net') WHERE id>0;
UPDATE `mallCategory` SET `image` = replace (`image`,'yjike.com','maxcx.net') WHERE id>0;