|
1 |
UPDATE `数据表名` SET `字段名` = replace (`字段名`,'要替换的内容','替换后的内容') |
登录phpMyadmin执行以上语句即可
例：
|
1 2 3 4 5 |
UPDATE wp_posts SET post_content = replace( post_content, 'AAA.com','BBB.com') ; UPDATE wp_comments SET comment_content = replace(comment_content, 'AAA.com', 'BBB.com') ; UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 'AAA.com', 'BBB.com') ; |
|
1 2 3 |
UPDATE `wp_posts` SET `guid` = replace (`guid`,'http://www.inlojv.com','http://xxx.inlojv.com'); UPDATE `wp_options` SET `option_value` = replace (`option_value`,'http://www.inlojv.com','http://xxx.inlojv.com'); UPDATE `wp_postmeta` SET `meta_value` = replace (`meta_value`,'http://www.inlojv.com','http://xxx.inlojv.com') |
