Basic find & replace help in MySQL

[EK]

Hello, I have a SQL db that imported a bunch of website addresses from an XML feed.

 

Some of the urls are formatted: http://google.com\folder

 

I would like to do a find/replace to search for the string 'google.com\' and then replace all the '\' with '/'

 

I tried to use:

 

SELECT REPLACE('google.com\', '\', '/');

 

but it returned:

 

#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 '\', '/')' at line 1

 

 

Any help would be appreciated

[ManiacDan]

\ is a special character that "escapes" the character after it.  You're probably familiar with it already, it's now you do strings with quotes in them:

'This is a string with a single quote, isn\'t it nice that we can have one like this?'

 

To get a literal backslash, double-escape it:

 

SELECT REPLACE('google.com\\', '\\', '/');

Note, however, that this doesn't fix the table.

 

-Dan