title: SQL Update Error with replace
body: <p>I can't see what is wrong with this SQL:</p>
  
  <pre><code>UPDATE Show
  SET    EnterOnine = replace(EnterOnine, 'http://projects.example.co.uk', 'http://www.example.co.uk')
  WHERE  EnterOnine LIKE '%http://projects.example.co.uk%'
  </code></pre>
  
  <p>I am getting this error when I enter this into PHPmyadmin:</p>
  
  <pre><code>#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 'Show SET EnterOnine = replace(EnterOnine, 'http://projects.example.co.uk' at line 1
  </code></pre>