title: How to search and replace all instances of a string within a database?
body: <p>I have a string that is contained inside of a wordpress install (the name of a server) thousands of times, across multiple columns, records and tables.</p>
  
  <p>I'd like to update it with the location of another server - we are moving the content over.</p>
  
  <p>So the source would be something like <a href="http://my-server1/some/link/to/something" rel="noreferrer">http://my-server1/some/link/to/something</a>, and I'd want to replace it with <a href="http://my-other-server/some/link/to/something" rel="noreferrer">http://my-other-server/some/link/to/something</a>. I'm essentially looking to repeat this process for every instance of <a href="http://my-server1" rel="noreferrer">http://my-server1</a>.</p>
  
  <p>Is there an easy way to do this in MySQL? A tool?
  Or do I sadly have to update every record problematically?</p>
  
  <p>Thank you,</p>