title: Replace shortcode in SQL database
body: <p>I'm trying replace this shortcode </p>
  
  <p><code>[RICH_REVIEWS_SHOW category=”all” num=”6″]</code></p>
  
  <p>with this shortcode </p>
  
  <p><code>[site_reviews summary count="3" hide="date"]</code> in a wordpress database. </p>
  
  <p>I've tried the plugin <strong>"better search and replace"</strong> but no luck.</p>
  
  <p>I've also tried using this code via the cpanel.</p>
  
  <pre><code>update wplq_posts set post_content =
  replace(post_content,'[RICH_REVIEWS_SHOW category=”all” num=”6″]','[site_reviews summary count="3" hide="date"]');
  </code></pre>
  
  <p>Initially no matches, if I remove certain parts of the shortcode I get some results. I'm a bit lost as to what will get the job the job done.</p>
  
  <p>Can anyone point me in the right direction.</p>
  
  <p>Thanks in advance.</p>