Advanced Search

Return to Snippet

Revision: 13620
at April 29, 2009 13:06 by zachharkey
Initial Code 
# Change all aliases with paths like foo/* to bar/* 
UPDATE url_alias SET dst = REPLACE(dst, 'foo/', 'bar/') WHERE dst LIKE 'foo/%';


# Delete all aliases with paths like foo/*
DELETE FROM `url_alias` WHERE dst LIKE 'category/%';
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
In case you don't feel like loading 3 pages to edit a single url alias.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MySQL queries for bulk editing Drupal url aliases

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
drupal

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL