Replacing backslash with forward slash in mySQL?

Question

I currently have a table with \paths\, but they need to be /paths/. Does anyone know what query I need to run in myPHPadmin to get it fixed?

Answer 1

SQL has replace function. Here is the link to mySQL docs.

update tablename set columnToUpdate = replace(columnToUpdate, '\\', '/');