ILIKE()

All functions > COMPARISON > ILIKE()

Case-insensitive wildcard match between two strings.

Signatures

Returns: TRUE, FALSE, or NULL

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

Notes

Uses the same % and _ wildcards as LIKE.

Related operators

• LIKE multiple

Examples

ILIKE — functional call

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

ILIKE — chained

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