How to fetch data containing back slashes

[Vinod Kumar Purvakam]

Dear All,

I have table called TestSplCharacters with two columns

1. ID integer
2. CHARCOL varchar(50)

I have inserted the data like this -- insert into TestSplCharacters values(1, 'Vinod\\Kumar');

and it has been inserted successfully.

But when i want to retrieve it from the Table using the command

select * from TestSplCharacters where CHARCOL LIKE 'Vinod\\Kumar' ESCAPE '\\';

no rows are selected.

but the same thing works fine with the command

select * from TestSplCharacters where CHARCOL = 'Vinod\\Kumar' ;

But generally anybody will use only LIKE operator for the character columns.

Is this a bug in MySql or am i doing any mistake ???

Anyone there to clear my doubt ???

Cheers,
Vinod Kumar Purvakam.