title: Remove span from column with introtext
body: <p>In my database, I have <code>my_table</code>, with column <code>introtext</code>.</p>
  
  <p>Some of the records include a span, I'd like to remove:</p>
  
  <pre><code>&lt;p&gt;&lt;span style="line-height: 1.7142857148;"&gt;Text text text...&lt;/span&gt;&lt;/p&gt;
  </code></pre>
  
  <p>And get instead something like:</p>
  
  <pre><code>&lt;p&gt;Text text text....&lt;/p&gt;
  </code></pre>
  
  <p>I need an SQL query to do this automatically. I am trying this:</p>
  
  <pre><code>UPDATE my_table
  SET introtext= REPLACE('introtext', '&lt;span style="line-height: 1.7142857148;"&gt;','')
  
  UPDATE my_table
  SET introtext= REPLACE('introtext', '&lt;/span&gt;','')
  </code></pre>
  
  <p>This is returning the error: </p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; 
  </code></pre>
  
  <p>How can I build a query that removes the span from the introtext no matter what style or classes it has without this error?</p>