In MariaDB, JSON_VALID() is a built-in function that allows you to check whether or not a value is a valid JSON document.
You pass the value as an argument, and JSON_VALID() returns 1 if it’s a valid JSON document, and 0 if not.
Tag: functions
ACOS() Function in Oracle
In Oracle, the ACOS() function returns the arccosine (inverse cosine) of its argument.
In other words, it returns the value whose cosine is the argument.
Continue readingABS() Function in Oracle
In Oracle, the ABS() function returns the absolute value of its argument.
The absolute value is the non-negative value of a real number without regard to its sign. It describes the distance from zero that a number is on the number line, without considering direction.
Continue readingMariaDB JSON_UNQUOTE() Explained
In MariaDB, JSON_UNQUOTE() is a built-in function that removes quotes from a JSON value. In other words, it “unquotes” a JSON value.
MariaDB JSON_TYPE() Explained
In MariaDB, JSON_TYPE() is a built-in function that returns the type of a JSON value, as a string.
MariaDB JSON_SEARCH() Explained
In MariaDB, JSON_SEARCH() is a built-in function that allows you to get the path to a given value in a JSON document.
It accepts the JSON document and a string as arguments, and returns the path to the given string within the document.
Continue readingMariaDB JSON_REMOVE() Explained
In MariaDB, JSON_REMOVE() is a built-in function that removes data from a JSON document and returns the result.
MariaDB JSON_QUOTE() Explained
In MariaDB, JSON_QUOTE() is a built-in function that produces a valid JSON string literal that can be included in a JSON document.
It wraps the string with double quote characters and escapes interior quotes and other special characters, returning a utf8mb4 string.
Continue readingMariaDB JSON_LOOSE() Explained
In MariaDB, JSON_LOOSE() is a built-in function that adds spaces to a JSON document to make it more readable.
It’s similar to the JSON_DETAILED() function, except that it doesn’t emphasise nested structures in the way that JSON_DETAILED() does.
For the opposite effect (i.e. to remove unnecessary spaces), use the JSON_COMPACT() function.
MariaDB JSON_LENGTH() Explained
In MariaDB, JSON_LENGTH() is a built-in function that returns the length of a JSON document.
When you call this function, you provide the JSON document as an argument. You can also provide a path argument to return the length of a value within the document.
Continue reading