regexp_like(string, pattern)
Query 1
presto:default> SELECT regexp_like('1a 2b 3c 6f', '\d+c') as expression;
Result
expression ------------ true
Here, the digit 3 has character c, hence the result is true.
Query 2
presto:default> SELECT regexp_like('1a 2b 3c 6f', '\d+e') as expression;
Result
expression ------------ false
Here, the character e is not in the regular expression.
apache_presto_sql_functions.htm
Advertisements