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, 257🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...