Menu

Articles

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

How the LEAST() function works in Mariadb?

The LEAST() function is a numeric function that returns the smallest value among a list of values.

How the MBRTouches() function works in Mariadb?

The MBRTouches() function is a useful tool for performing spatial queries in Mariadb.

How the SECOND() function works in Mariadb?

The SECOND() function in MariaDB is used to extract the seconds part from a TIME or DATETIME value.

How the IsEmpty() function works in Mariadb?

The IsEmpty() function is a spatial function that returns 1 if the geometry argument is an empty geometry collection, or 0 otherwise.

How the LCASE() function works in Mariadb?

The LCASE() function is a string function that converts all the characters in a given string to lowercase.

How the MBROverlaps() function works in Mariadb?

The MBROverlaps() function is a useful tool for performing spatial queries in Mariadb.

How the SEC_TO_TIME() function works in Mariadb?

The SEC_TO_TIME() function in MariaDB is used to convert a value representing seconds into a TIME value.

How the IsClosed() function works in Mariadb?

The MariaDB IsClosed() function is used to determine if a given LINESTRING’s start and end points are the same.

How the LAST_VALUE() function works in Mariadb?

The LAST_VALUE() function is a window function that returns the last value of an expression within a partition or a result set.

How the MBRIntersects() function works in Mariadb?

The MBRIntersects() function is a useful tool for performing spatial queries in Mariadb.