dede php替换,如何批量替换修改 phpwin/dede/WordPress 文章标题内容

4、输入 SQL 语句后，点“执行”即可；

pw替换文章标题

UPDATE pw_threads SET subject=REPLACE(subject,'要修改得内容',' 修改后得内容');

语法要大写，字段和表要加 ``，字符串要加''，数字可以直接写，`` '' 是不一样的，` 是 esc 下面那个

空间关注

查找关注量最大：pw_memberdata.follows

DELETE FROM `pw_space` WHERE `pw_space`.`descript` LIKE '%tianhoo.net%';

DELETE FROM `pw_oboard` WHERE `pw_oboard`.`title` LIKE '%tianhoo.net%';

删除留言板广告(只删除pw_obxxx那个表不行，最新留言写入了用户缓存)

UPDATE `pw_usercache` SET  `value` =  'a:0:{}' WHERE `pw_usercache`.`type` LIKE  'messageboard' AND  `pw_usercache`.`value` LIKE  '%tianhoo.net%';

删除站内信通知

DELETE FROM `pw_ms_messages` WHERE `pw_ms_messages`.`content` LIKE '%haowush.com%';

DELETE pw_weibo_relations FROM pw_weibo_relations WHERE pw_weibo_relations.uid=2158895

DELETE pw_weibo_relations FROM pw_weibo_relations WHERE pw_weibo_relations.authorid=2158895

DELETE pw_weibo_content FROM pw_weibo_content WHERE pw_weibo_content.uid=2158895

DELETE pw_tmsgs, pw_threads FROM pw_tmsgs, pw_threads  WHERE pw_threads.tid>20109374 AND w_threads.authorid=2158897

DELETE pw_threads FROM pw_threads WHERE pw_threads.fid<>19

DELETE pw_threads FROM pw_threads WHERE pw_threads.type<>104

参考语句：UPDATE pre_forum_post SET message=REPLACE(message,'要替换的内容','新内容');

删空间简介带反社会内容

pw_attention

pw_weibo_relations

DELETE pw_weibo_relations FROM pw_weibo_relations WHERE pw_weibo_relations.uid=1190368

DELETE pw_weibo_relations FROM pw_weibo_relations WHERE pw_weibo_relations.authorid=1190099

DELETE pw_attention FROM pw_attention WHERE pw_attention.friendid=3105161

DELETE pw_attention FROM pw_attention WHERE pw_attention.uid=3105161

WordPress 批量修改/替换文章内容

SQL 语句：UPDATE wp_posts SET post_content = replace(post_content, ‘旧内容’,’新内容’);

WordPress 批量修改/替换文章摘要

SQL语句：UPDATE wp_posts SET post_excerpt = replace(post_excerpt, ‘旧内容’,’新内容’);

WordPress 批量修改/替换文章作者

SQL 语句：UPDATE wp_posts SET post_author = 原作者id WHERE post_author = 新作者id;

WordPress 批量修改/替换评论中的敏感词

SQL 语句：UPDATE wp_comments SET comment_content = REPLACE( comment_content,’敏感词’,’***’);

根据昵称删除：

SQL 语句：DELETE FROM wp_comments WHERE comment_author =’昵称’;

根据 URL 链接删除

SQL 语句：DELETE FROM wp_comments WHERE comment_author_url LIKE ‘%www.baidu.com%’;

根据留言者的 Email 删除

SQL 语句：DELETE FROM wp_comments WHERE comment_author_email =’admin@baidu.com’;