Array

LIST_CONTAINS

DuckDB

Mengecek apakah list mengandung elemen tertentu. Return TRUE/FALSE.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

LIST_CONTAINS(list, element) | LIST_HAS(list, element) | ARRAY_CONTAINS(list, element)

Parameter

listLISTwajib

List yang akan dicek

elementANYwajib

Elemen yang dicari

Contoh Penggunaan

Cek Keberadaan Elemen

SQL

1 SELECT LIST_CONTAINS([1, 2, 3, 4, 5], 3) AS found;

Cek apakah 3 ada dalam list.

Hasil

true

Cek String

SQL

1 SELECT LIST_CONTAINS(['apple', 'banana', 'cherry'], 'banana') AS found;

Cek string dalam list.

Hasil

true

Filter dengan LIST_CONTAINS

SQL

1 SELECT
2   product_name,
3   tags
4 FROM products
5 WHERE LIST_CONTAINS(tags, 'sale');

Filter produk yang memiliki tag 'sale'.

Multiple Checks

SQL

1 SELECT
2   product_name,
3   LIST_CONTAINS(tags, 'new') AS is_new,
4   LIST_CONTAINS(tags, 'sale') AS on_sale,
5   LIST_CONTAINS(tags, 'featured') AS featured
6 FROM products;

Multiple boolean checks pada list.

Fungsi Equivalen di Database Lain

ARRAY_CONTAINS

Snowflake

JSON_CONTAINS

MySQL

Fungsi Terkait

LIST_POSITION

Kembali ke DuckDB Functions

1	SELECT
2	product_name,
3	tags
4	FROM products
5	WHERE LIST_CONTAINS(tags, 'sale');

1	SELECT
2	product_name,
3	LIST_CONTAINS(tags, 'new') AS is_new,
4	LIST_CONTAINS(tags, 'sale') AS on_sale,
5	LIST_CONTAINS(tags, 'featured') AS featured
6	FROM products;