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, 471🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...