How to query for backslashes in an SQL Database

I am trying to run the following command in phpMyAdmin:

update table_name set category_name = replace(category_name, ‘//’, ‘/’)

Code (markup):

This query was so I could remove double-backslashes, but I am getting the following error:

and here is what MySQL said:

I searched the internet and couldn't find anything that could help me, if anyone knows what I should replace the backslashes with, please let me know!

 

A backslash is "\", not "/" - to escape a backslash, use another, i.e. '\\'

http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html

I don't think you need to escape forward slashes at all.

 

If you're trying to output through PHP you could use

stripslashes($string);

PHP:

 

Sorry, I meant to say forward slashes (I just gave it the wrong title). And I don't think I need to escape it, I just need a different syntax for forward slashes (from my understanding).

I wasn't trying to create a PHP output, I was trying to run an SQL command to remove double forward slashes in a certain category.