JSON

JSON_CONTAINS_PATH

MySQL

Mengecek apakah path tertentu ada di JSON document. Berguna untuk validasi struktur JSON.

Tipe hasil: INT (0 or 1)Diperbarui: 7 Jan 2026

Syntax

SQL

JSON_CONTAINS_PATH(json_doc, one_or_all, path[, path] ...)

json_docJSONwajib

JSON document

one_or_allVARCHARwajib

'one' = minimal satu path ada, 'all' = semua path harus ada

pathVARCHARwajib

Path yang akan dicek

SQL

1 SELECT JSON_CONTAINS_PATH('{"name": "John", "age": 30}', 'one', '$.name') AS has_name;

Mengecek apakah path $.name ada.

Hasil

has_name: 1

SQL

1 SELECT JSON_CONTAINS_PATH('{"name": "John"}', 'all', '$.name', '$.email') AS has_both;

Mengecek apakah kedua path ada.

Hasil

has_both: 0 (email tidak ada)

SQL

1 SELECT * FROM users
2 WHERE JSON_CONTAINS_PATH(profile, 'all', '$.name', '$.email', '$.phone');

Filter user dengan profile lengkap.

Hasil

(users with complete profile)

1	SELECT * FROM users
2	WHERE JSON_CONTAINS_PATH(profile, 'all', '$.name', '$.email', '$.phone');