This is done by adding the ESCAPE clause to your LIKE expression. The character that is specified with the ESCAPE clause will “invalidate” the following wildcard character. You can use any character you like (just not a wildcard character). Most people use a \ because that is what many programming languages also use.

So your query would result in:

But you can just as well use any other character:


Leave a Reply