In MariaDB, JSON_UNQUOTE() is a built-in function that removes quotes from a JSON value. In other words, it “unquotes” a JSON value.
Relational
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.
MariaDB 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.
MariaDB 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.
How to do a DELETE Pass-Through Query in SQL Server
In SQL Server, the OPENQUERY rowset function enables you to execute a pass-through query on a linked server.
OPENQUERY is commonly referenced in the FROM clause of a query as if it were a table, but it can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement.
This article presents an example of using OPENQUERY to do an DELETE pass-through query.
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.
MariaDB JSON_KEYS() Explained
In MariaDB, JSON_KEYS() is a built-in function that returns an array of the top-level keys from a JSON document. If a path is provided, it returns the top-level keys from that path.
It excludes keys from nested sub-objects in the specified level.
Also, if the selected object is empty, an empty array is returned.
MariaDB JSON_SET() Explained
In MariaDB, JSON_SET() is a built-in function that updates or inserts data into a JSON document and returns the result.Â
JSON_SET() can update and insert data, whereas JSON_INSERT() can only insert data, and JSON_REPLACE() can only update data.