JSON

JSON_UNQUOTE

MySQL

Menghilangkan quotes dari JSON string value. Konversi JSON string ke SQL string.

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_UNQUOTE(json_val)

json_valJSONwajib

Nilai JSON (biasanya dari JSON_EXTRACT)

SQL

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

Dari '"John"' menjadi 'John'.

Hasil

name: John (tanpa quotes)

SQL

1 SELECT data->>'$.name' AS name
2 FROM users;

Shorthand untuk JSON_UNQUOTE(JSON_EXTRACT(...)).

Hasil

name: John

SQL

1 SELECT JSON_UNQUOTE('"Hello\\nWorld"') AS decoded;

Decode newline escape sequence.

Hasil

decoded: Hello\nWorld (dengan newline)

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