Links

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

REGEXP_LIKE(STRING, PATTERN)

Arguments

STRING

Type: string
A sequence of characters.

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$'.

Returns

Type: boolean
A boolean value indicating whether or not PATTERN is contained with STRING.

Examples

STRING
PATTERN
Output
1a 2b 14m
\d+b
true
1a 2b 14m
^1
true
ab abc abcc bac
ab*
true
ab a1bc ab1cc bac
a1*
true
2 a1bc ab11cc 311
a1(2)
true
2 a1bc ab11cc 311
a1(2)sdag
false
null
\d+
null

Transformation job example

SQL

CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
SELECT
customer_address_city
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE (time_filter())
AND REGEXP_LIKE(customer_address_city, '(.*ville$)|(.*burg$)')
LIMIT 3;

Query result

customer_address_city
Sykesville
Collierville
Jeffersonville