REGEXP

Checks whether a string matches a regular expression pattern.

Analyze Syntax

func.regexp(<str> REGEXP <pattern>)

Analyze Examples

get_column(table, 'email').regexp_match('^[a-z]+@')

┌───────────┐
 (boolean)  
└───────────┘

SQL Syntax

REGEXP(<str> REGEXP <pattern>)

SQL Examples

SELECT email FROM users WHERE email REGEXP '^[a-z]+@[a-z]+\\.com$';

┌───────────────────┐
 alice@example.com  
└───────────────────┘