title: Change a h tag in an MySQL string column
body: <p>I have a MySQL table with column where fields are strings beginning like this:</p>
  
  <pre><code>&lt;h2&gt;texttext&lt;/h2&gt;texttexttext....
  
  &lt;h2&gt;text2text2&lt;/h2&gt;texttexte......
  </code></pre>
  
  <p>I would like to replace h2 to h1 tag for all fields in the column. I have tried using the REPLACE query like this one:</p>
  
  <pre><code>UPDATE myTable 
  SET column = REPLACE(column, 'h2&gt;', 'h1&gt;')
  </code></pre>
  
  <p>But it did not work.</p>
  
  <p>Please let me know what I am doing wrong.</p>
  
  <p>Thank you.</p>