wordpress数据库批量替换【文章内容】
- 技术
- 2020-02-19
- 10223热度
- 0评论
参考
UPDATE wp_posts SET
post_content = replace(post_content, '搜索引擎优化', '搜索引擎营销');
举例
UPDATE wp_posts SET
post_content = replace(post_content, 'width="700" height="500"', 'width="1060" height="600"
');
UPDATE wp_posts SET
post_content = replace(post_content, 'width="800" height="571"', 'width="1060" height="600"
');
width="700" height="500"
width="800" height="570"
width="1060" height="600"