WordPress批量修改文章发布状态,计划发布修改已发布,发布状态待审核等

计划发布修改为一键发布

UPDATE `wp_posts` 
SET `post_status` ='publish' WHERE (`post_status`='future');

待审核一键已发布

UPDATE `wp_posts` 
SET `post_status` ='publish' WHERE (`post_status`='pending');

已发布一键待审核

UPDATE `wp_posts` 
SET `post_status` ='pending' WHERE (`post_status`='publish');

 

阅读剩余
THE END