MySQL批量更改WordPress关闭和打开评论功能的方法
- 作者: 用户61403927
- 来源: 51数据库
- 2020-08-30
|
use wordpressDB;
select * from wp_posts where post_title="终端服务器超出了最大允许连接";
select * from wp_posts where post_title="ubuntu关闭图形界面";
set sql_safe_updates=0;
UPDATE wp_posts SET comment_status='open' where post_title="终端服务器超出了最大允许连接";
set sql_safe_updates=1;
select post_title,comment_status,ping_status from wp_posts where comment_status="closed"; //查看
set sql_safe_updates=0;
UPDATE wp_posts SET comment_status='open'; //批量打开评论
set sql_safe_updates=1;
UPDATE wp_posts SET comment_status='closed'; //批量关闭评论
|
推荐阅读
