Articles

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

How the SUBSTRING() function works in Mariadb?

The SUBSTRING() function in MariaDB is used to extract a substring from a given string, based on the specified starting position and optional length.

How the JSON_OBJECT_FILTER_KEYS() function works in Mariadb?

The JSON_OBJECT_FILTER_KEYS() function is a built-in function in Mariadb that allows you to filter a JSON object by keeping certain keys.

How the MAKETIME() function works in Mariadb?

The MAKETIME() function is a time function that returns a time value that is composed of a given hour, minute, and second.

How the MultiPointFromWKB() function works in Mariadb?

The MultiPointFromWKB() function is a spatial function that converts a well-known binary (WKB) representation of a multipoint geometry into a multipoint value.

How the SUBSTRING_INDEX() function works in Mariadb?

The SUBSTRING_INDEX() function in MariaDB is used to return a substring from a given string, up to a specified delimiter.

How the JSON_MERGE() function works in Mariadb?

The JSON_MERGE() function is a built-in function in Mariadb that allows you to merge two or more JSON documents into one.

How the MAKEDATE() function works in Mariadb?

The MAKEDATE() function is a date function that returns a date value that is composed of a given year and a given day of the year.

How the MultiPointFromText() function works in Mariadb?

The MultiPointFromText() function is a spatial function that creates a multipoint geometry from a well-known text (WKT) representation of the multipoint.

How the SUBSTR() function works in Mariadb?

The SUBSTR() function in MariaDB is used to extract a substring from a given string.

How the JSON_MERGE_PRESERVE() function works in Mariadb?

The JSON_MERGE_PRESERVE() function is a JSON function that merges two or more JSON documents and returns the result as a JSON document.