mysql - How to handle query search with special characters /(forward slash) and \(backslash)

Question

I have a table where a column allows special characters like '/' (forward slash) and '' (back slash).

Now when I try to search such records from table, I am unable to get those.

For example: abc\def or abc/def

I am generating a search query like:

select * from table1_1 where column10 like '%abc\def%'

It is returning 0 rows, but actually there is 1 record existing that should be returned. How do I write the query in this case?

Answer 1

In MySQL, this works:

select * from Table1
where column10 like '%abc\\\\def%'

FIDDLE

Backslash is an escape prefix for both strings and LIKE patterns. So you need to double it once for LIKE, and again for string literal syntax.