MySQL Replace not working

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