title: Replace SQL string in all tables at once
body: <p>My goal is to add <code>www</code> to addresses, replacing <code>http://mywebsite.org</code> with <code>http://www.mywebsite.org</code> in all tables at once.</p>
  
  <p>I have tried the following, but it doesn't seem to work:</p>
  
  <pre><code>SELECT Replace('http://mywebsite.org', 'mywebsite.org', 'www.mywebsite.org')
  </code></pre>
  
  <p>Any help?</p>
  
  <p>new edit:</p>
  
  <p>i try to change this in wp_option, its a option_value string: </p>
  
  <pre><code>UPDATE wp_options SET option_value = 'http://www.iemj.org' WHERE option_value = 'http://iemj.org'  
  </code></pre>
  
  <p>-- doesnt change</p>
  
  <pre><code> a:4:{s:25:"dashboard_recent_comments";a:1:{s:5:"items";i:5;}s:24:"dashboard_incoming_links";a:5:{s:4:"home";s:19:"http://www.iemj.org";s:4:"link";s:95:"http://blogsearch.google.com/blogsearch?scoring=d&amp;partner=wordpress&amp;q=link:http://www.iemj.org/";s:3:"url";s:124:"http://blogsearch.google.com/blogsearch_feeds?scoring=d&amp;ie=utf-8&amp;num=10&amp;output=rss&amp;partner=wordpress&amp;q=link:http://iemj.org/";s:5:"items";i:10;s:9:"show_date";b:0;}s:17:"dashboard_primary";a:7:{s:4:"link";s:26:"http://wordpress.org/news/";s:3:"url";s:31:"http://wordpress.org/news/feed/";s:5:"title";s:14:"WordPress Blog";s:5:"items";i:2;s:12:"show_summary";i:1;s:11:"show_author";i:0;s:9:"show_date";i:1;}s:19:"dashboard_secondary";a:7:{s:4:"link";s:28:"http://planet.wordpress.org/";s:3:"url";s:33:"http://planet.wordpress.org/feed/";s:5:"title";s:20:"Other WordPress News";s:5:"items";i:5;s:12:"show_summary";i:0;s:11:"show_author";i:0;s:9:"show_date";i:0;}}
  </code></pre>