NOT_LIKE()

All functions > COMPARISON > NOT_LIKE()

Returns TRUE if a string does NOT match a specified pattern with wildcards.

Signatures

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

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

Notes

• Opposite of LIKE
• Wildcard pattern matching (%, _)
• Case-sensitive matching
• NULL inputs return NULL

Related operators

• NOT LIKE

Examples

NOT_LIKE — functional call

SELECT
    f1 := NOT_LIKE('hello', 'world') -- `NOT_LIKE(expr, pattern)` matches keyword `NOT LIKE`
;

NOT_LIKE — chained

SELECT
    f1 := ('hello').NOT_LIKE('world') -- Receiver is the string; argument is the pattern
;