WordPress 批次開啟/關閉留言功能，教學說明： https://sofree.cc/wordpress-bulk-comment-close/

bulk-comments-1.sql

/*批次關閉所有文章留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_type = 'post' ;

bulk-comments-10.sql

/*針對全部草稿文章關閉留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_status = 'draft' AND post_type = 'post' ;

bulk-comments-2.sql

/*批次開啟所有文章留言*/
UPDATE wp_posts SET comment_status = 'open' WHERE post_type = 'post' ;

bulk-comments-3.sql

/*批次開啟所有頁面留言*/
UPDATE wp_posts SET comment_status = 'open' WHERE post_type = 'page' ;

bulk-comments-4.sql

/*批次關閉所有頁面留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_type = 'page' ;

bulk-comments-5.sql

/*批次關閉所有文章Trackback通知引用*/
UPDATE wp_posts SET ping_status = 'closed' WHERE post_type = 'post' ;

bulk-comments-6.sql

/*批次開啟所有文章Trackback通知引用*/
UPDATE wp_posts SET ping_status = 'open' WHERE post_type = 'post' ;

bulk-comments-7.sql

/*針對全部已發表文章開啟留言*/
UPDATE wp_posts SET comment_status = 'open' WHERE post_status = 'publish' AND post_type = 'post' ;

bulk-comments-8.sql

/*針對全部已發表文章關閉留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_status = 'publish' AND post_type = 'post' ;

bulk-comments-9.sql

/*針對全部草稿文章開啟留言*/
UPDATE wp_posts SET comment_status = 'open' WHERE post_status = 'draft' AND post_type = 'post' ;