小编先后研究了phpwin/dede/WordPress。这里一次分享给大家。
操作步骤:
1、登录 phpMyAdmin 面板,找到需要操作的数据库;
2、找到点击菜单栏的 SQL 选项;
3、在 SQL 语句输入框中,输入您想执行的 SQL 语句;
4、输入 SQL 语句后,点“执行”即可;
pw替换文章标题
UPDATE pw_threads SET subject=REPLACE(subject,'要修改得内容',' 修改后得内容');
dede织梦得就简单了,只需要后台找到批量维护就可以操作了。
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’;
本文地址:http://www.sd124.com/article/2020/0415/234497.html
《如何批量替换修改 phpwin/dede/WordPress 文章标题内容》由闪电下载吧整理并发布,欢迎转载!