Retrieving string with \(backslash) from mysql table

Hello,
I am having table in which one field is having value with \ (backslash). When I search that string it doesn't return result.


Here is my query.

select * from table where field like ''%A\Value%' . Even if the result is there in the database . Is there any way to retrieve the value for the value containing \ in it. Please help me. Thanks in advance.

 

Use double slashed e.g.

select * from table where field like ''%A\\Value%'

 

It worked by using 4 \s instead of two...

select * from table where field like ''%A\\\\Value%'

Code (markup):

 

try this

select * from table where field like '%\\%'

Code (markup):