Skip to content

SQL Regex Operators

Yellowbrick supports the following operators for pattern matching:

OperatorDescription
~Find strings that match (case-sensitive)
~*Find strings that match (case-insensitive)
!~Find strings that do not match (case-sensitive)
!~*Find strings that do not match (case-insensitive)

These operators locate matches anywhere in the string.

Note: These operators are different from the operators that represent LIKE and ILIKE (~~, ~~*, and so on).

Parent topic:SQL Operators and Pattern Matching Functions