워드프레스 guid 변경 쿼리문

워드프레스 DB의 wp_posts 테이블 guid 변경
- 포스트 검색1 : select * from `wp_posts` where `post_type` = 'post' ORDER BY 'ID'
- 포스트 검색2 : select * from `wp_posts` where `post_type` = 'post' AND `ID` = '56574';

https://mysite.com/archives/56574

https://mysite.com/?p=56574

- UPDATE wp_posts SET guid = REPLACE(guid, 'oldurl.com', 'newurl.com') WHERE guid LIKE 'http://oldurl.com/%';

- UPDATE wp_posts SET guid = REPLACE(guid, 'https://mysite.com/archives/', 'https://mysite.com/?p=') WHERE guid LIKE 'https://mysite.com/archives/%';

 

 

Reference :
How to change all the guid in posts table? : https://wordpress.stackexchange.com/questions/211156/how-to-change-all-the-guid-in-posts-table