title: Double Quotes in MySQL UPDATE Query
body: <p>I'm using the following <a href="https://stackoverflow.com/questions/125230/mysql-search-and-replace-some-text-in-a-field">answer</a> to make changes to a text field in multiple records in a MySQL table.  </p>
  
  <p>I need to change a small portion of each record where a URL occurs with double quotes.</p>
  
  <p>Example record:</p>
  
  <pre><code>a:32:{s:5:"title";s:23:"Texas"footertext";s:220:"&lt;a class=\"footerlink\" href=\"%ORIGINALPOSTURL%\" target=\"_blank\" rel=\"nofollow\"&gt;CLICK HERE FOR MORE INFO &amp;amp; PHOTOS&lt;/a&gt;}
  </code></pre>
  
  <p>I want to remove the <code>target=\"_blank\"</code></p>
  
  <p>I'm not updating any records I suspect due to the use of double quotes in the target value I'm trying to replace.  I've tried with and without backslashes.  These 4 backslashes on each side of the double quotes you see here worked when performing a SELECT in phpMyAdmin.  I've tried a single backslash with zero records updated too.</p>
  
  <p>Neither of these worked</p>
  
  <pre><code>UPDATE wp_autoblog SET feed_meta = replace(feed_meta,'target=\\\\"_blank\\\\"','');
  
  UPDATE wp_autoblog SET feed_meta = replace(feed_meta,'target=\"_blank\"','');
  </code></pre>