Skip to content

52 Tech Tips

Tips about all sorts of technology!

Menu
  • About
  • About Us
  • eLearning Resources
  • My Top Hosting Picks 2022
  • Privacy Policy
Menu

MySQL find and replace

Posted on February 20, 2012

Recently, I have been helping a friend with his new website using WordPress. We initially set up the site under one of his existing domains prior to purchasing a dedicated domain name for the site we were developing. He actually posted a lot of content prior to getting the new domain so when it came time to make the move, it was clearly necessary to perform a “find and replace” on the MySQL database to update the URL on all of the posts he had created.

After a little google searching I found this site – http://wordcastnet.com/2010/how-to-find-search-replace-and-delete-within-your-wordpress-mysql-database/

Everything I needed was explained. What a relief. After a few minutes of backing up and trial and error, I was able to run the query and update over 70 posts. I want to keep this query handy for the future. I’m pretty sure there will be a time when it is needed again and most likely for far more.

[wp_ad_camp_1]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Pages

  • About
  • About Us
  • eLearning Resources
  • My Top Hosting Picks 2022
  • Privacy Policy

Blogroll

  • Apple Mac Rumors
  • Ars Technica
  • CNET Cheapskate
  • CNET Tech News
  • Dell Deals
  • Digital SLR Cameras
  • Engadget
  • GRC
  • My Digital Life
  • Secunia
  • SSL Labs
  • SuperSite for Windows
  • This Week in Tech

hosting

  • AN Hosting
  • Fused Network
  • Host Duplex
  • Lunar Pages
  • Media Temple Hosting
  • Square Space

Mac

  • Bare Feats

photography

  • Aperture Nature Workshops
  • Don’t Look Here
  • Strobist

tech jobs

  • Dice
  • eLance
  • eLearning Jobs
  • Monster

Recent Posts

  • Security Freeze Your Account With The Three Largest Credit Bureaus
  • Need a Google Domain Alternative
  • Steps to get started with dividend investing
  • Now may a great time to buy a car
  • My Favorite Note Taking Apps
©2025 52 Tech Tips | Design: Newspaperly WordPress Theme