Advanced Search

Return to Snippet

Revision: 13660
at April 30, 2009 18:55 by zachharkey
Initial Code 
# 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';
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
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](http://drupal.org/node/134535)

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MySQL queries for performing bulk  operations on Drupal nodes

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
drupal

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL