JSON

JSON_VALUE

MySQL

Mengekstrak nilai skalar dari JSON dan mengembalikan sebagai SQL type (bukan JSON). Tersedia sejak MySQL 8.0.21.

Tipe hasil: VARCHAR/specified typeDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_VALUE(json_doc, path [RETURNING type])

json_docJSONwajib

Dokumen JSON sumber

pathstringwajib

Path expression ke nilai skalar

RETURNING typeclauseopsional

Tipe data hasil (opsional)

SQL

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

Hasil tanpa quotes (langsung string).

Hasil

name: John (tanpa quotes)

SQL

1 SELECT JSON_VALUE(data, '$.age' RETURNING SIGNED) AS age
2 FROM users;

Ekstrak dan cast ke integer.

Hasil

age: 25 (as integer)

SQL

1 SELECT * FROM products
2 WHERE JSON_VALUE(specs, '$.price' RETURNING DECIMAL(10,2)) > 100;

Filter berdasarkan nilai JSON.

Hasil

(products with price > 100)

JSON_VALUE

BigQuery

JSON_EXTRACT_PATH_TEXT

Snowflake

1	SELECT JSON_VALUE(data, '$.age' RETURNING SIGNED) AS age
2	FROM users;

1	SELECT * FROM products
2	WHERE JSON_VALUE(specs, '$.price' RETURNING DECIMAL(10,2)) > 100;