LIKE()

All functions > COMPARISON > LIKE()

Returns TRUE if a string matches a specified pattern with wildcards.

Signatures

Returns: TRUE if the string matches, FALSE if not, NULL if an input is NULL

LIKE(expr1: VARCHAR, expr2: VARCHAR, [escape: VARCHAR]) → BOOLEAN

Notes

• Wildcard pattern matching
• % matches zero or more characters
• _ matches exactly one character
• Case-sensitive matching
• NULL inputs return NULL
• An escape character can treat % and _ literally (default escape is backslash in the lowering template)

Related operators

• LIKE

Examples

LIKE — functional call

SELECT
    f1 := LIKE('ab', 'a%') -- `LIKE(expr, pattern)` matches keyword `LIKE`
;

LIKE — chained

SELECT
    f1 := ('ab').LIKE('a%') -- Receiver is the string; argument is the pattern
;