title: Remove string from field using MySQL
body: <p>I want to remove the string;</p>
  
  <pre><code>&lt;p&gt;&lt;span style="color: #008000;"&gt;-- Instant Download --&lt;/span&gt;&lt;/p&gt;
  </code></pre>
  
  <p>from a the field description_short in the table ps_product_lang I have tried the following SQL query</p>
  
  <pre><code>update ps_product_lang set description_short = replace(description_short, ‘&lt;p&gt;&lt;span style="color: #008000;"&gt;-- Instant Download --&lt;/span&gt;&lt;/p&gt;’, ‘’);
  </code></pre>
  
  <p>But I get the error message</p>
  
  <p>"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>-- Instant Download --</p>â€™, â€˜â€™)' at line 1"</p>
  
  <p>I believe its the quotes and --&lt; that may be the issue, does anyone know how to make the query work> Thanks</p>