aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/like/like_clause_escape.sql
blob: 9f7f67fb3619a12868de42af09fb5066a6b91406 (plain) (blame)
1
2
3
4
5
select key, subkey, value from plato.Input
where
value like "!%z" escape "!" or
value || "_" like "_?_" escape "?" or
value || "!" like "ddd!!" escape "!";