Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the JSON_VALID() function works in Mariadb?

The JSON_VALID() function is a simple but useful function for validating whether a JSON value is well-formed and valid.

How the NumPoints() function works in Mariadb?

The NumPoints() function is a spatial function in Mariadb that returns the number of points in a linestring, or 0 if the argument is not a linestring.

How the TO_CHAR() function works in Mariadb?

The TO_CHAR() function in MariaDB is used to convert a date, datetime, time or timestamp value into a string representation.

How the JSON_UNQUOTE() function works in Mariadb?

The JSON_UNQUOTE() function is a simple but useful function for removing the double quotes from a JSON value.

How the NumInteriorRings() function works in Mariadb?

The NumInteriorRings() function is a spatial function in Mariadb that returns the number of interior rings in a polygon, or 0 if the argument is not a polygon.

How the TO_BASE64() function works in Mariadb?

The TO_BASE64() function in MariaDB is used to convert a string or binary value into its Base64 encoded representation.

How the JSON_TYPE() function works in Mariadb?

The JSON_TYPE() function is a simple but useful function for inspecting the type of a JSON value.

How the NumGeometries() function works in Mariadb?

The NumGeometries() function is a spatial function in Mariadb that returns the number of geometries in a geometry collection, or 1 if the argument is not a geometry collection.

How the TIMESTAMPDIFF() function works in Mariadb?

The TIMESTAMPDIFF() function in MariaDB is used to calculate the difference between two date or datetime expressions.

How the JSON_TABLE() function works in Mariadb?

The JSON_TABLE() function is a powerful and versatile tool for extracting data from JSON documents and converting them into tabular format.