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, 3228🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...