JSON_QUOTE(string)

MySQL 8.4 🇮🇩 Bahasa Indonesia

Mengutip string sebagai nilai JSON dengan membungkusnya dengan karakter kutip ganda dan keluar dari kutipan interior dan karakter lainnya, lalu mengembalikan hasilnya sebagai string utf8mb4. Mengembalikan NULL jika argumennya NULL.

Syntax

MYSQL

SELECT JSON_QUOTE('null'), JSON_QUOTE('"null"');
+--------------------+----------------------+
| JSON_QUOTE('null') | JSON_QUOTE('"null"') |
+--------------------+----------------------+
| "null"             | "\"null\""           |
+--------------------+----------------------+
SELECT JSON_QUOTE('[1, 2, 3]');
+-------------------------+
| JSON_QUOTE('[1, 2, 3]') |
+-------------------------+
| "[1, 2, 3]"             |
+-------------------------+

Contoh

Example

This function is typically used to produce a valid JSON string literal for inclusion within a JSON document.

MYSQL

SELECT JSON_QUOTE('null'), JSON_QUOTE('"null"');
+--------------------+----------------------+
| JSON_QUOTE('null') | JSON_QUOTE('"null"') |
+--------------------+----------------------+
| "null"             | "\"null\""           |
+--------------------+----------------------+
SELECT JSON_QUOTE('[1, 2, 3]');
+-------------------------+
| JSON_QUOTE('[1, 2, 3]') |
+-------------------------+
| "[1, 2, 3]"             |
+-------------------------+