老谢博客

//替换评论者的链接  
UPDATE wp_comments SET comment_author_url = REPLACE( comment_author_url, ’http://oldurl’, ’http://newurl’ );  
//替换文章中的链接  
UPDATE wp_posts SET post_content = REPLACE( post_content, ’http://oldurl’, ’http://newurl’ );  
//替换评论者的电子邮箱地址  
UPDATE wp_comments SET comment_author_email = REPLACE( comment_author_email, ’old-email@address.com’, ’new-email@address.com’ );  
//替换评论者的昵称  
UPDATE wp_comments SET comment_author = REPLACE( comment_author, ’old_author’, ’new_author’ );

//替换评论者的链接 UPDATE wp_comments SET comment_author_url = REPLACE( comment_author_url, ’http://oldurl’, ’http://newurl’ ); //替换文章中的链接 UPDATE wp_posts SET post_content = REPLACE( post_content, ’http://oldurl’, ’http://newurl’ ); //替换评论者的电子邮箱地址 UPDATE wp_comments SET comment_author_email = REPLACE( comment_author_email, ’old-email@address.com’, ’new-email@address.com’ ); //替换评论者的昵称 UPDATE wp_comments SET comment_author = REPLACE( comment_author, ’old_author’, ’new_author’ );