title: mysql replace query not working
body: <p>This is my code:</p>
  
  <pre><code>UPDATE post SET pagetext = replace(pagetext, 'hiiiiiii','lol')
  </code></pre>
  
  <p>But it doesn't work and I get the following error:</p>
  
  <blockquote>
    <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 ''hiiiiiii''lol') FROM post WHERE' at line 1</p>
  </blockquote>
  
  <p>Any ideas?</p>