/ Published in: MySQL

Administering more than one node at a time through the Drupal admin interface is like drinking a milkshake through a buckytube.
How to use phpmyadmin and sql to perform mass operations on nodes
Expand |
Embed | Plain Text
# Change the promote setting of all book nodes that are promoted to the front page. UPDATE `node` SET `promote` = '0' WHERE `type` = 'book' AND `promote` = '1'; # Promote all book nodes to the front page UPDATE `node` SET `promote` = '1' WHERE `type` = 'book' AND `promote` = '0'; # Enable commenting for all book pages UPDATE `node` SET `comment` = '2' WHERE `type` = 'book';
You need to login to post a comment.