[WordPress] 投稿記事内ã®æ–‡å—列をSQLæ–‡ã§ä¸€æ‹¬ç½®æ›WordPressã§æŠ•ç¨¿ã•ã‚ŒãŸè¨˜äº‹ãªã©ã‚’SQLæ–‡ã§ä¸€æ‹¬ç½®æ›ã™ã‚‹ãŸã‚ã®ãƒ¡ãƒ¢ã§ã™ã€‚ ã“ã®æ–¹æ³•ã§ã¯ã€SQL文を使用ã™ã‚‹ã¨ãã«phpMyAdminã®ç®¡ç†ç”»é¢ã‚’使ã£ã¦ã„ã¾ã™ã€‚ 投稿記事内ã®URLを一括置æ›ã™ã‚‹ WordPressã§ãƒ–ãƒã‚°ã‚’é‹å–¶ã—ã¦ã„ã‚‹ã¨ã㫠“投稿記事内ã«è¨˜è¿°ã—ã¦ã„ãŸã‚µã‚¤ãƒˆã®URLã®ãƒªãƒ³ã‚¯ãŒåˆ‡ã‚Œã¦ã„ãŸâ€ ã‚‚ã—ã㯠“ドメインãŒå¤‰æ›´ã•ã‚Œã¦ã„ãŸâ€ ãªã©ã¨ã„ã†æ™‚ãŒã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ 以下ã«ã€ãã®URLã‚’phpMyAdmin上ã‹ã‚‰SQLæ–‡ã§ä¸€æ‹¬ç½®æ›ã™ã‚‹æ–¹æ³•ã‚’ã”紹介ã—ã¾ã™ã€‚ 1. phpMyAdminã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’表示ã—ã¦wp_postsã‚’é¸æŠž ã¾ãšã€phpMyAdminã®ç®¡ç†ç”»é¢ã‚’é–‹ã„ã¦ã€ã‚µã‚¤ãƒ‰ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ãƒ–ãƒã‚°ã§ä½¿ã‚ã‚Œã¦ã„るデータベースをé¸æŠžã—ã¦ä¸‹ã•ã„。投稿記事内ã®URLãŒè¨˜è¿°ã•ã‚Œã¦ã„ã‚‹ã®ã¯ wp_posts ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ルåãªã®ã§ã€wp_posts ã‚’é¸æŠžã—ã¾ã™ã€‚ 2. テーブルã®ãƒ
![[WordPress] 投稿記事内ã®æ–‡å—列をSQLæ–‡ã§ä¸€æ‹¬ç½®æ›](https://cdn-ak-scissors.b.st-hatena.com/image/square/2193540f58a4e6efbb5fbb2539826c5acf414768/height=288;version=1;width=512/http%3A%2F%2Fsyake-labo.com%2Fblog%2Fwp-content%2Fuploads%2F2013%2F11%2Fwordpress-sql-thumbnail.jpg)
{{#tags}}- {{label}}
{{/tags}}