JSON

JSON_KEYS

MySQL

Mengembalikan array berisi semua key dari JSON object. Berguna untuk introspeksi struktur JSON.

Tipe hasil: JSON (array)Diperbarui: 7 Jan 2026

Syntax

SQL

JSON_KEYS(json_doc[, path])

json_docJSONwajib

JSON document (harus object)

pathVARCHARopsional

JSON path ke object tertentu

SQL

1 SELECT JSON_KEYS('{"name": "John", "age": 30, "city": "NYC"}') AS keys;

Mendapatkan semua key dari object.

Hasil

keys: ["name", "age", "city"]

SQL

1 SELECT JSON_KEYS('{"user": {"id": 1, "name": "John"}}', '$.user') AS user_keys;

Get keys dari nested object.

Hasil

user_keys: ["id", "name"]

SQL

1 SELECT id, JSON_KEYS(metadata) AS fields
2 FROM products
3 WHERE metadata IS NOT NULL;

Discover fields dalam metadata JSON.

Hasil

(array of keys per row)

OBJECT_KEYS

Snowflake

JSON_KEYS

BigQuery

JSON_KEYS

DuckDB

1	SELECT id, JSON_KEYS(metadata) AS fields
2	FROM products
3	WHERE metadata IS NOT NULL;