Skip to content

Instantly share code, notes, and snippets.

@benhosmer

benhosmer/disable_comments.sql

Created August 6, 2013 18:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save benhosmer/6167285 to your computer and use it in GitHub Desktop.
Save benhosmer/6167285 to your computer and use it in GitHub Desktop.
Download ZIP
Mass disable comments for existing Drupal nodes. Credit: https://drupal.org/node/103064#comment-4922950
Raw
disable_comments.sql
UPDATE `node` SET `comment` = '2' WHERE `type` = 'toolkit';
UPDATE node_revision SET comment=2 WHERE nid IN (SELECT nid FROM node WHERE node.type='toolkit');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment