title: MySql Replace part of a string with escape characters
body: <p>I'm trying to do a simple update the old url in a database table with a new relative url, but I keep getting "0 rows affected". I think it might have to do with the escape characters in the string?</p>
  
  <p>The URLs in the column 'data' now are structured with the backslash.
  Here's my SQL:</p>
  
  <pre><code> UPDATE vjfl_sliderimages
   SET data = REPLACE(data, '\/myolddomain.com\/images\/', '\/images\/')
  </code></pre>
  
  <p>This should work to change the URL of every image from myolddomain.com/images/ to /images/ but for some reason it just doesn't have any affect.</p>