Advanced Search

Return to Snippet

Revision: 33572
at October 10, 2010 21:04 by arnach
Initial Code 
update wp_posts
set guid = concat('http://www.example.com/?p=',ID)
where guid = ''
and post_status = 'publish'
and post_type = 'post';

update wp_posts
set guid = concat('http://www.example.com/?post_id=',ID)
where guid = ''
and post_status = 'publish'
and post_type = 'page';
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Updating guid for posts and pages in Wordpress database

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, wordpress, update

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL