WordPressデータベース内のテキストを簡単に検索・置換する方法

18件のコメント返信を残す

1. Chris

   Can do search and replace HTML code? I have snippets of (table td tr) code I would like to replace.

   返信

   • WPBeginner Support

     It would depend on where that code was added from, you should normally be able to edit the page that it is on for modifying the code.

     返信

     管理者

2. Shahala

   Hey there! could you please tell me how can I do this find and replace in sql for a word only in specific language?
   I tried using language queries but din’t work out!
   I really appreciate any help towards this. Thank you

   返信

   • WPBeginner Support

     Unless I hear otherwise, we don’t have a language specific search at the moment sadly.

     返信

     管理者

3. Saud Shah

   How can we change 2018 to 2019 in categories and page titles with this plugin or phpmyadmin

   返信

   • WPBeginner Support

     For the post and page titles, you would search the wp_posts table but, for changing categories and their urls you would want to do that manually and create 301 redirects.

     返信

     管理者

4. Aminu

   please, how do you replace texts in posts title?

   返信

5. Vishal

   Thanks a lot for this. I was looking for the exact same solution.

   返信

6. Anang

   Thanks a lot. It saves me hours of work.

   返信

7. RCdiy

   I want to replace all instances of “OpenTx” with “OpenTX” but skipping URLs. So basically only what the viewer sees… How do I do this? I’ve installed both Search Replace and Better Search Replace but they also replace in the URLs…

   返信

8. Piter

   I tried plugins “Search $ replace” and “Better Search Replace” but there was no effect. Links in my posts was there. But…

   Thanks a lot for code metod, it works fine. It takes only few seconds.

   返信

9. samowal

   Thank you very much, man.

   返信

10. Peter

    You already wrote an article about this last year: https://www.wpbeginner.com/plugins/search-and-replace-plugin-for-wordpress-database/

    返信

    • WPBeginner Support

      Thanks for noticing This is actually a rewrite of an old article that only showed the code method. We decided to add the plugin method and more explanation to it.

      返信

      管理者

11. KMurphy

    Is this something that would work in migrating a site – to change the DB urls to a new location?

    返信

    • Kim Hopkins

      I just did this.

      返信

12. Oscar Estepa

    I’m not 100% sure but I’d say the SQL query can’t handle serialised data. If you search & replace your database using the suggested SQL query you’ll break the serialised data and get yourself into lots of troubles down the road like widgets not working, images dissappearing, broken javascript, etc.

    It’s well explained in this link http://davidcoveney.com/782/mysql-database-search-replace-with-serialized-php/

    So better look for a plugin, script or tool which handles serialised data, like the suggested plugin Better Search Replace or the interconnectit script.

    Personally I use search and replace tool integrated in WP-CLI, in my experience it’s the best and fastest tool out there, never had a problem so far, tested in dozens of websites. For less savvy people, I’d recommend a plugin since WP-CLI is a terminal command tool and might not suite everyone.

    返信

13. Damien Carbery

    I like internetconnect/it’s Database Search and Replace Script.

    Unlike the phpMyAdmin example in the article, it will search all fields. It will also do a dummy run.

    返信