title: SQL string replace wildcard
body: <p>I have a table X with column Y, that contains text like this:</p>
  
  <pre><code>Click &lt;a href=""http://www.stackoverflow.com""&gt;here&lt;/a&gt; to redeem
  </code></pre>
  
  <p>I need it turned into: </p>
  
  <pre><code>Click &lt;a href="http://www.stackoverflow.com"&gt;here&lt;/a&gt; to redeem
  </code></pre>
  
  <p>ie. remove the extra pair of quotes</p>
  
  <p>The text outside of the ""url"" may be anything.</p>
  
  <p>Is it something like this? </p>
  
  <pre><code>Update X SET Y = REPLACE(Y, '""%""', '"%"' );
  </code></pre>