Find & Replace Data within phpMyAdmin

Hello ...

I'm trying to find a replace forward slashes with back slashes within a specific field  on a mysql table.

The SQL i'm using is as follows within phpMyadmin

UPDATE images_T SET image_path = replace(image_path, "\", "/");

Open in new window

But when I try this I receive the following message

ERROR: Unclosed quote @ 70
STR: "
SQL: UPDATE xcart_images_T_bck SET image_path = replace(image_path, "\", "/");

Any Ideas?

Many Thanks
LVL 1
Shafiq KhanAsked:
Who is Participating?
 
lwadwellCommented:
It may be thinking you are escaping the quote ... try
UPDATE images_T SET image_path = replace(image_path, "\\", "/");
0
 
Shafiq KhanAuthor Commented:
Great.. Many Thanks.

That did the trick :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.