Escape wildcard characters #oracle #sql

Escape wildcard characters.md

Escape wildcard characters The LIKE keyword allows for string searches. The '_' wild card character is used to match exactly one character, while '%' is used to match zero or more occurrences of any characters. These characters can be escaped in SQL. Examples:

SELECT name FROM emp
WHERE id LIKE '%/_%' ESCAPE '/';


SELECT name FROM emp
WHERE id LIKE '%\%%' ESCAPE '\';