JSON

JSON_CONTAINS

DuckDB

Mengecek apakah JSON array atau object mengandung nilai tertentu. Mengembalikan boolean.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

JSON_CONTAINS(json, value)

Parameter

jsonJSONwajib

JSON array atau object yang akan dicek

valueJSON/VARCHARwajib

Nilai yang dicari

Contoh Penggunaan

Cek Array Contains Value

SQL

1 SELECT
2   JSON_CONTAINS('[1, 2, 3, 4, 5]', '3') as contains_3,
3   JSON_CONTAINS('["a", "b", "c"]', '"b"') as contains_b,
4   JSON_CONTAINS('[1, 2, 3]', '5') as contains_5;

Mengecek keberadaan nilai dalam JSON array.

Hasil

contains_3	contains_b	contains_5
true	true	false

Filter Produk dengan Tag

SQL

1 SELECT product_name, tags
2 FROM products
3 WHERE JSON_CONTAINS(tags, '"electronics"');

Mencari produk yang memiliki tag 'electronics'.

Hasil

product_name	tags
Laptop	["electronics", "computer"]
Phone	["electronics", "mobile"]

Cek User Permissions

SQL

1 SELECT
2   user_name,
3   permissions,
4   JSON_CONTAINS(permissions, '"admin"') as is_admin,
5   JSON_CONTAINS(permissions, '"write"') as can_write
6 FROM users;

Mengecek permission dalam array JSON.

Hasil

user_name	permissions	is_admin	can_write
Budi	["admin","read","write"]	true	true
Ani	["read","write"]	false	true
Eko	["read"]	false	false

Kembali ke DuckDB Functions

1	SELECT
2	JSON_CONTAINS('[1, 2, 3, 4, 5]', '3') as contains_3,
3	JSON_CONTAINS('["a", "b", "c"]', '"b"') as contains_b,
4	JSON_CONTAINS('[1, 2, 3]', '5') as contains_5;

1	SELECT product_name, tags
2	FROM products
3	WHERE JSON_CONTAINS(tags, '"electronics"');

1	SELECT
2	user_name,
3	permissions,
4	JSON_CONTAINS(permissions, '"admin"') as is_admin,
5	JSON_CONTAINS(permissions, '"write"') as can_write
6	FROM users;