title: SQL UPDATE with Replace throwing 1064 error inside replace statement
body: <p>I have used the REPLACE Statement before with success, but for some reason, this statement keeps throwing a 1064 error?</p>
  
  <pre><code>UPDATE `wp_UPCP_Item_Images` SET `Item_Image_URL` = REPLACE (`Item_Image_URL`,
  'http://www.salestraininganddevelopment', 'http://tilesunlimitedny') 
  </code></pre>
  
  <p>but keep getting this error?</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 
  ''http://www.salestraininganddevelopment''http://tilesunlimitedny') FROM `wp_UPC' at line 1
  </code></pre>
  
  <p>Screenshot as requested:
  <a href="https://i.stack.imgur.com/vZuMW.jpg" rel="nofollow noreferrer">mysql screenshot</a></p>
  
  <p>What am I missing, just keep staring at this statement to see if i can find it but, I am lost.
  Read through all the suggested questions and cant seem to find anything that works.
  Thanks a ton, Jeff</p>