Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Operators for matching strings against regular expression patterns. Regular expressions provide more powerful pattern matching than LIKE.
1<string> ~ <pattern>
2<string> ~* <pattern>
3<string> !~ <pattern>
4<string> !~* <pattern>| Operator | Description |
|---|---|
~ | Matches regular expression, case-sensitive |
~* | Matches regular expression, case-insensitive |
!~ | Doesn’t match regular expression, case-sensitive |
!~* | Doesn’t match regular expression, case-insensitive |
<string>: The string to match against.<pattern>: The regular expression pattern.Returns a boolean value indicating whether the string matches (or does not match) the pattern.
LIKE patterns, supporting complex patterns like repetition, alternation, and character classes.LIKE, regular expressions match anywhere within the string by default. Use ^ and $ anchors to match the start and end of the string.Match a pattern with case sensitivity.
1SELECT 'thomas' ~ '.*thomas.*' AS result;Returns true.
1SELECT 'thomas' ~ '.*Thomas.*' AS result;Returns false because case does not match.
Match a pattern ignoring case.
1SELECT 'thomas' ~* '.*Thomas.*' AS result;Returns true.
Check that a string does not match a pattern.
1SELECT 'thomas' !~ '.*Thomas.*' AS result;Returns true because case-sensitive match fails.
1SELECT 'thomas' !~* '.*vadim.*' AS result;Returns true because the pattern is not found.
Match one of multiple patterns.
1SELECT 'abc' ~ '(b|d)' AS result;Returns true because the string contains ‘b’.
Match patterns at the beginning of a string.
1SELECT 'abc' ~ '^a' AS result;Returns true because the string starts with ‘a’.
1SELECT 'abc' ~ '^(b|c)' AS result;Returns false because the string does not start with ‘b’ or ‘c’.
j