title: SQL string to replace content between 2 words
body: <p>I have searched for this and many others talk about replace command but I don`t wanna do a misstake with that.</p>
  
  <p>My case is: I have a Wordpress blog and a script insert content in the posts. Now I wanna delete this new content but to keep the old one.</p>
  
  <p>Its something like "This is content of a post about me" its the old content, and now the script insert another line, and the value of the field looks like <code>"This is content of a post about me &lt;div class="spnsor"&gt;&lt;a [...]&lt;/div&gt;".</code></p>
  
  <p>In this part I have a different link from a post to post. But is the same construction with the same div and class.</p>
  
  <p>I have over 2000 posts so is to much to edit every post.</p>
  
  <p>How can I fix this from Mysql? </p>
  
  <p>Its ok this command?
  <code>UPDATE wp_posts SET post_content = REPLACE ( post_content, '&lt;div class="spnsor"&gt;*&lt;/div&gt;', '' )</code></p>