regex_match

relationalai.semantics.std.strings

regex_match(value: StringValue, regex: StringValue) -> Expression

Check if the value matches the given regex.

Parameters

• value

  (StringValue) - The string value to match against.

• regex

  (StringValue) - The regular expression pattern.

Returns

• Expression - An Expression that evaluates to true if value matches the regex pattern.

Examples

Match strings using regular expressions:

select(Person.name).where(strings.regex_match(Person.name, r".*ohn.*"))
select(Person.name).where(not_(strings.regex_match("ohn", Person.name)))