JSON

JSON_VALUE

BigQuery

Mengekstrak scalar value dari JSON sebagai STRING (SQL standard).

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_VALUE(json_expression, json_path)

json_expressionJSONwajib

Nilai JSON native

json_pathSTRINGwajib

JSONPath expression

SQL

1 SELECT
2   JSON_VALUE(JSON '{"name": "John", "age": 30}', '$.name') as name,
3   JSON_VALUE(JSON '{"name": "John", "age": 30}', '$.age') as age;

Mengekstrak nilai scalar.

Hasil

name	age
John	30

JSON_VALUE

MySQL

JSON_EXTRACT_PATH_TEXT

Snowflake

1	SELECT
2	JSON_VALUE(JSON '{"name": "John", "age": 30}', '$.name') as name,
3	JSON_VALUE(JSON '{"name": "John", "age": 30}', '$.age') as age;