Articles

How the WEEK() function works in Mariadb?

The MariaDB WEEK() function is one such feature that allows users to extract the week number from a date.

How the VERSION() function works in Mariadb?

The MariaDB VERSION() function is quite useful for users who need to know the version of the MariaDB server they are working with.

How the VARIANCE() function works in Mariadb?

In MariaDB, the VARIANCE() function is used to calculate this measure for a set of numbers.

How the VAR_SAMP() function works in Mariadb?

The VAR_SAMP() function in MariaDB is used to calculate the sample variance of a set of values.

How the VAR_POP() function works in Mariadb?

The VAR_POP() function in MariaDB is used to calculate the population variance of a set of values.

How MariaDB UUID() Generates Version 1 UUIDs

Learn how MariaDB UUID() generates version 1 identifiers, what their time and node fields mean, and how UUIDv1 differs from UUIDv4 and UUIDv7.

How the REGEXP() function works in Mariadb?

The REGEXP() function is a string function that returns 1 if a string matches a given regular expression pattern, or 0 otherwise.

How the UUID_SHORT() function works in Mariadb?

The UUID_SHORT() function in MariaDB is used to generate a 64-bit universally unique identifier (UUID).

How the PointOnSurface() function works in Mariadb?

The PointOnSurface() function is a built-in function in Mariadb that returns a point geometry that is guaranteed to lie on the surface of a given geometry.

How the REGEXP_SUBSTR() function works in Mariadb?

The REGEXP_SUBSTR() function is a string function that returns the substring that matches a given regular expression pattern in a subject string.