I have back slashes stored in mysql.
I want to remove backslash ‘\’. So, I run query like
UPDATE table_name set col_name = replace(col_name, "Equipe d\'Olivier", "Equipe d'Olivier");
More intrestingly, even if I query something like
Select * from table_name where column_name = "Equipe d\'Olivier"
It returns row even with
"Equipe d'Olivier" as well
I could not get any idea on this. How can I replace or remove that backslash