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;

版权属于：Joyber

本文链接：https://blog.qqvbc.com/default/94.html

转载时须注明出处及本声明