Array

ARRAY_CONTAINS

Snowflake

Mengecek apakah nilai ada dalam array.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

ARRAY_CONTAINS(value, array)

valueVARIANTwajib

Nilai yang dicari

arrayARRAYwajib

Array untuk dicari

SQL

1 SELECT ARRAY_CONTAINS(2::VARIANT, ARRAY_CONSTRUCT(1, 2, 3)) as found;

Cek apakah 2 ada di array.

Hasil

true

SQL

1 SELECT *
2 FROM orders
3 WHERE ARRAY_CONTAINS('VIP'::VARIANT, tags);

Filter orders dengan tag VIP.

JSON_CONTAINS

MySQL

LIST_CONTAINS

DuckDB

1	SELECT *
2	FROM orders
3	WHERE ARRAY_CONTAINS('VIP'::VARIANT, tags);