Categories: Binary, String

ILIKE

Compares two strings and returns true if they match.

Syntax

ILIKE(expression1 varchar, expression2 varchar) → boolean

  • expression1: First expression to compare.
  • expression2: Expression to compare to expression1.

Examples

SELECT ILIKE('Dremio', 'dremio')
-- True
SELECT ILIKE('dremio', 'warehouse')
-- False