Advanced Search

Return to Snippet

Revision: 50415
at August 20, 2011 00:59 by S_Park
Initial Code 
UPDATE wp_posts SET guid = replace(guid, "dev.domain.co.uk", "www.domain.co.uk")
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Useful for when moving a Wordpress installation from, e.g., development to live. 'wp_posts' is the table name, 'guid' is the table field. Alter as appropriate.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Wordpress SQL Find & Replace

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL