How do I disable comments or remove spam comments in WordPress via phpMyAdmin?

To manage WordPress comments via phpMyAdmin:

• Disable comments on all posts:

  UPDATE wp_posts SET comment_status = 'closed';

• Remove spam comments:

  DELETE FROM wp_comments WHERE comment_approved = 'spam';

• Delete comments within a specific ID range:

  DELETE FROM wp_comments WHERE comment_ID > 79 AND comment_ID < 296;

Run these queries in phpMyAdmin’s SQL tab for your WordPress database. Always back up your database before making changes.