How to replace an escape character with a string

Question

I am trying to replace an escape character with a string, but the query gives me an irrelevant result

eg- char - '\' replace with "adfc" below request

SELECT REPLACE("abcdefgh\i","\\", "adfc" ); 

output - abcdefghi

Desired conclusion - abcdefghadfci

How can I achieve this in mysql?

Answer 1

in my.ini add this line:

 sql-mode="NO_BACKSLASH_ESCAPES" 

then restart the mysql server and replace the query with the following:

 SELECT REPLACE("abcdefgh\i","\", "adfc" ); 

link here

Answer 2

use this:

 SELECT REPLACE("abcdefgh\\i","\\", "adfc" ); 

a single escape character will automatically exit the character, so you need to put a double escape character to remove the escape character.