Ever since version 10.3.1, MariaDB has included both a LENGTH() function and a LENGTHB() function.
That second one has a B at the end of the name. So it’s kind of like Length A and Length B, except that Length A doesn’t have the A.
Confused?
I was, when I first encountered LENGTHB(). I already knew about LENGTH(), so why the need for a “B” version?
Let’s find out.
Below is a list of the JSON functions available in MariaDB.
Below are 4 functions that enable you to return the hour from a time value in MariaDB.
MariaDB has quite a number of functions that return the day from a date. It all depends on how you want to do it, and what you mean by “day”.
MariaDB needs to know whether you want the day name, the day of the week number, the day of the month, day of year, etc.
Below are 8 functions that enable you to return the day from a date in MariaDB, in its various forms.
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.
In MariaDB, JSON_UNQUOTE() is a built-in function that removes quotes from a JSON value. In other words, it “unquotes” a JSON value.
In MariaDB, JSON_TYPE() is a built-in function that returns the type of a JSON value, as a string.
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.
In MariaDB, JSON_REMOVE() is a built-in function that removes data from a JSON document and returns the result.
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.