Problem searching and replacing ' \ '

[markstille]

Hi

I have a problem searching and replacing paths in my database:

I want to change all paths from : \new\new1\new2\image.jpg

to: /new/new1/new2/image.jpg

I am trying the following SQL statement but it doesn't work.

code:

update menu set image = replace(image, "\", "/");

What am I doing wrong???

[felgall]

replace(image, "\\", "/")

[Brad080283]

UPDATE table SET field=REPLACE(table.field, '\\','/');

[markstille]

excellent, works!

many thanks