Skip to content

Instantly share code, notes, and snippets.

@mynameispj

mynameispj/MySQL

Created April 8, 2014 04:12
Show Gist options
  • Save mynameispj/10090023 to your computer and use it in GitHub Desktop.
Save mynameispj/10090023 to your computer and use it in GitHub Desktop.
Download ZIP
Drupal 7 - Turn on comments for all nodes in a content type via MySQL
Raw
MySQL
UPDATE node SET comment = 2 WHERE type = 'foo'
UPDATE node_revision SET comment = 2 WHERE nid IN (SELECT nid FROM node WHERE type = 'foo')
//'foo' = the machine name of your content type
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment