Help with MySQL query

[Hasher]

Hi All,

Have a problem related to IH5 . In my MySQl database 'products' table and 'products_image' column I have strings like 'Images\A995\A995.jpg'

Anything with a backslash wont work with Image Handler . So need to swap this out . For example Images/A995/A995.jpg to Images\A995\A995.jpg

UPDATE `products` SET `products_image` = REPLACE(`products_image`,`\`,`/`)

Above is code i'm working with in PHPadmin. I guess I'm having problems with the backslash

\\ A backslash (\) character

Can anyone help with this one ?

[dbltoe]

In this case, you would want to replace rather than update.
https://www.w3resource.com/mysql/str...e-function.php

[lat9]

... or this StackOverflow posting: https://stackoverflow.com/questions/...slash-in-mysql. Note, especially, the last comment on that posting.

[Hasher]

Thanks all, got it working !

It was the escaping of \ that tripped me up