REGEXP_LIKE
Evaluates a regular expression pattern and determines if it is contained within the given string.
This function is similar to the LIKE
operator, except that the pattern only needs to be contained within the string, rather than needing to match all of the string. In other words, this performs a contains operation rather than a match operation. You can match the entire string by anchoring the pattern using ^
and $
.
Syntax
Arguments
STRING
STRING
Type: string
A sequence of characters.
PATTERN
PATTERN
Type: string
A regular expression pattern.
This pattern must be a Java regular expression. String literals are unescaped. For example, to match '\abc'
, a regular expression would be '^\\abc$'
.
See the RegEx pattern table for more information.
Returns
Type: Boolean
A Boolean value indicating whether or not PATTERN
is contained with STRING
.
Examples
STRING | PATTERN | Output |
---|---|---|
'1a 2b 14m' | '\d+b' |
|
'1a 2b 14m' | '^1' |
|
'ab abc abcc bac' | 'ab*' |
|
'ab a1bc ab1cc bac' | 'a1*' |
|
'2 a1bc ab11cc 311' | 'a1(2)' |
|
'2 a1bc ab11cc 311' | 'a1(2)sdag' |
|
| '\d+' |
|
Transformation job example
SQL
Query result
customer_address_city |
---|
Sykesville |
Collierville |
Jeffersonville |
Last updated