Articles

How the UTC_TIMESTAMP() function works in Mariadb?

The UTC_TIMESTAMP() function in MariaDB returns the current date and time in the Coordinated Universal Time (UTC) time zone.

How the PointN() function works in Mariadb?

The PointN() function is a built-in function in Mariadb that returns the N-th point of a linestring geometry.

How the REGEXP_REPLACE() function works in Mariadb?

The REGEXP_REPLACE() function is a string function that returns a new string where the occurrences of a regular expression pattern are replaced by a specified replacement string in a subject string.

How the UTC_TIME() function works in Mariadb?

The UTC_TIME() function in MariaDB is used to retrieve the current time in the UTC (Coordinated Universal Time) time zone.

How the PointFromWKB() function works in Mariadb?

The PointFromWKB() function is a built-in function in Mariadb that returns a point geometry that represents a location in a two-dimensional space.

How the REGEXP_INSTR() function works in Mariadb?

The REGEXP_INSTR() function is a string function in Mariadb that returns the position of the first occurrence of a regular expression pattern in a string.

How the UTC_DATE() function works in Mariadb?

The UTC_DATE() function in MariaDB is used to retrieve the current date in the UTC (Coordinated Universal Time) time zone.

How the PointFromText() function works in Mariadb?

The PointFromText() function is a built-in function in Mariadb that returns a point geometry that represents a location in a two-dimensional space.

How the RANK() function works in Mariadb?

The RANK() function is a window function in Mariadb that returns the rank of a row within a partition of a result set.

MariaDB USER(): Return the Client User and Host

Learn what MariaDB USER() returns, how it differs from CURRENT_USER(), and how to inspect the connecting client and host.