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, 241🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...