MySQL, find records containing an escape character

A quick article for a question I had to ask myself recently. How to make in MySQL to return all the records which contain the backslash character, which is also considered as an escape character?

The answer is quite simple actually, but not immediate.
If you want to find all records with a field containing a backslash, just run this query:

SELECT * FROM article where title LIKE '%\%' ESCAPE '|'

Leave a Reply