Articles

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

How the IS_FREE_LOCK() function works in Mariadb?

The IS_FREE_LOCK() function is a miscellaneous function that tests whether a named lock is free or not.

How the REVERSE() function works in Mariadb?

The REVERSE() function in MariaDB is a string function that returns the supplied string with all its characters reversed.

How the DATE_SUB() function works in Mariadb?

The DATE_SUB() function is a built-in function in Mariadb that subtracts a specified time interval from a date or datetime value and returns the result as a new date or datetime value.

How the GeometryN() function works in Mariadb?

The GeometryN() function is a spatial function that returns the N-th geometry in a geometry collection.

How the INTERVAL() function works in Mariadb?

The INTERVAL() function is a numeric function that returns the index of the interval that a given value falls into.

MariaDB REPLACE() Function: Syntax and Examples

Learn how MariaDB REPLACE() replaces every case-sensitive substring match, handles NULL arguments, and differs from the REPLACE INTO statement.

How the DATE_FORMAT() function works in Mariadb?

The DATE_FORMAT() function is a built-in function in Mariadb that formats a date or datetime value according to a specified format string and returns the result as a new string value.

How the GeometryFromWKB() function works in Mariadb?

The GeometryFromWKB() function is a spatial function that creates a geometry object from a well-known binary (WKB) representation.

How the INTERSECTS() function works in Mariadb?

The INTERSECTS() function is a spatial function that tests whether two geometries intersect or not.

How the REPEAT() function works in Mariadb?

The REPEAT() function in MariaDB is a string function that returns a string repeated a certain number of times.