Skip to content
Advertisement

Tag: backslash

sql query to replace backslashes ‘\’ with ‘/’

I know very little about sql queries but I need a query to replace ‘\’ with ‘/’ I have a Wordpress database where there are characters in a long text string that look like this in phpMyAdmin Browse. ‘\uploads\photos\’ It needs to be ‘/uploads/photos/’. I want a query to find ‘\uploads\photos\’ so I can make sure the query is working.

Advertisement