Collections:
JSON_VALID() - Validating JSON Value
How to verify if value is a JSON (JavaScript Object Notation) value using the JSON_VALID() function?
✍: FYIcenter.com
JSON_VALID(val) is a MySQL built-in function that
returns 1 if the given value is a valid JSON value.
For example:
SELECT JSON_VALID('hello'), JSON_VALID('"hello"');
-- +---------------------+-----------------------+
-- | JSON_VALID('hello') | JSON_VALID('"hello"') |
-- +---------------------+-----------------------+
-- | 0 | 1 |
-- +---------------------+-----------------------+
SELECT JSON_VALID('123'), JSON_VALID('"123"');
-- +-------------------+---------------------+
-- | JSON_VALID('123') | JSON_VALID('"123"') |
-- +-------------------+---------------------+
-- | 1 | 1 |
-- +-------------------+---------------------+
SELECT JSON_VALID('{"a": 1}'), JSON_VALID('(1,2,3)');
-- +------------------------+-----------------------+
-- | JSON_VALID('{"a": 1}') | JSON_VALID('(1,2,3)') |
-- +------------------------+-----------------------+
-- | 1 | 0 |
-- +------------------------+-----------------------+
Reference information of the JSON_VALID() function:
JSON_VALID(val): int Returns 0 or 1 to indicate whether a value is valid JSON value. Arguments, return value and availability: val: Required. The value to be verified int: Return value. The verification result. Available since MySQL 5.7.
⇒ JSON_VALUE() - Converting JSON Value
⇐ JSON_UNQUOTE() - Unquoting JSON String
2023-12-17, 1271🔥, 0💬
Popular Posts:
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...