数据库批量替换图片网址

UPDATE wp_posts SET post_content= replace(post_content,'http://www.xxxx.com/img/','https://xxx.top/img/');