MySQL queries for performing bulk operations on Drupal nodes

# 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';