MySQL Replace not working
Try replacing double-quotes " by single-quotes ', and use a double back-slash. \\

UPDATE tbl 
set col_name = replace(col_name, 'Equipe d\\''Olivier', 'Equipe d''Olivier');


db&lt;>fiddle here