search

statesman / photoblog.statesman.com

The Statesman's photo blog, running on Wordpress
Other
0 stars 0 forks source link

Make photo URLs relative #1

Closed achavez closed 9 years ago

achavez commented 9 years ago

The below MySQL query was used to update URLs within post content and to update GUIDs for some posts:

UPDATE `wp_posts`
 SET `guid` = replace(guid, 'http://www.statesman.com/classifieds/content/gen/photoblog/uploads/', 'http://photoblog.statesman.com/wp-content/uploads/');
UPDATE `wp_posts`
 SET `guid` = replace(guid, 'http://aasphoto.wpengine.com/', 'http://photoblog.statesman.com/');
UPDATE `wp_posts`
 SET `post_content` = replace(post_content, ' href="http://aasphoto.wpengine.com/wp-content/uploads/', ' href="/wp-content/uploads/');
UPDATE `wp_posts`
 SET `post_content` = replace(post_content, ' src="http://aasphoto.wpengine.com/wp-content/uploads/', ' src="/wp-content/uploads/');
UPDATE `wp_posts`
 SET `post_content` = replace(post_content, ' href="http://photoblog.statesman.com/wp-content/uploads/', ' href="/wp-content/uploads/');
UPDATE `wp_posts`
 SET `post_content` = replace(post_content, ' src="http://photoblog.statesman.com/wp-content/uploads/', ' src="/wp-content/uploads/');
UPDATE `wp_posts`
 SET `post_content` = replace(post_content, ' src="http://www.statesman.com/classifieds/content/gen/photoblog/uploads/', ' src="/wp-content/uploads/');