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, 2885🔥, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...