JSON

JSON_EXTRACT

MySQL

Mengekstrak data dari dokumen JSON menggunakan path expression. Mengembalikan JSON value.

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_EXTRACT(json_doc, path[, path] ...)

json_docJSONwajib

Dokumen JSON sumber

pathstringwajib

Path expression ($.key, $[0], dll)

SQL

1 SELECT JSON_EXTRACT(data, '$.name') AS name
2 FROM users;

Mengambil property 'name' dari JSON.

Hasil

(extracted name with quotes: "John")

SQL

1 SELECT JSON_EXTRACT(tags, '$[0]') AS first_tag
2 FROM posts;

Mengambil element pertama array.

Hasil

(first tag)

SQL

1 SELECT JSON_EXTRACT(profile, '$.address.city') AS city
2 FROM customers;

Akses nested property.

Hasil

(nested city value)

JSON_EXTRACT_PATH

PostgreSQL

GET_PATH

Snowflake

JSON_EXTRACT

BigQuery

JSON_EXTRACT

DuckDB

1	SELECT JSON_EXTRACT(profile, '$.address.city') AS city
2	FROM customers;