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, 332🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...