LIKE
Use the LIKE pattern matching function in PlaidCloud Lakehouse. Matches a string against a pattern using % (any characters) and _ (single character).
Pattern Matching Functions
This section provides reference information for the pattern matching functions in PlaidCloud Lakehouse.
REGEXP
Learn how to use the REGEXP pattern matching function in PlaidCloud Lakehouse. Checks whether a string matches a regular expression pattern.
REGEXP_COUNT
Use the REGEXP_COUNT pattern matching function in PlaidCloud Lakehouse. Returns the number of times a regular expression pattern occurs in a string.
REGEXP_EXTRACT
Learn how to use the REGEXP_EXTRACT pattern matching function in PlaidCloud Lakehouse. Extracts the first substring that matches a regular expression pattern.
REGEXP_EXTRACT_ALL
Learn how to use the REGEXP_EXTRACT_ALL pattern matching function in PlaidCloud Lakehouse. Extracts all substrings that match a regular expression pattern.
REGEXP_REPLACE
Use the REGEXP_REPLACE pattern matching function in PlaidCloud Lakehouse. Replaces substrings matching a regular expression pattern with a replacement string.