ARRAY_CONTAINS
Learn how to use the ARRAY_CONTAINS array function in PlaidCloud Lakehouse. Checks whether an array contains a specific element - with syntax and examples.
Checks whether an array contains a specific element.
Analyze Syntax
func.array_contains([1, 2, 3], 2)
Analyze Examples
func.array_contains([1, 2, 3], 2)
┌───┐
│ 1 │
└───┘
SQL Syntax
ARRAY_CONTAINS([1, 2, 3], 2)
SQL Examples
SELECT ARRAY_CONTAINS([1, 2, 3], 2);
┌───┐
│ 1 │
└───┘