Articles

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

How the LineFromWKB() function works in Mariadb?

The LineFromWKB() function is a spatial function that converts a binary representation of a line to a geometry value.

The MID() function is a useful tool for extracting a substring from a given string.

Learn MariaDB SHA2() syntax, supported digest lengths, NULL behavior, and why a fast SHA-2 digest is not a password hash.

The JSON_ARRAY_INSERT() function is a JSON function that inserts values into an array within a JSON document.

The LineFromText() function is a spatial function that converts a text representation of a line to a geometry value.

The MICROSECOND() function is a useful tool for extracting the microsecond part of a time or datetime value.

Learn MariaDB SHA1() syntax, its 40-character SHA-1 result, the SHA() alias, and why it is not for password storage.

The JSON_ARRAY_APPEND() function is a JSON function that appends values to the end of an array within a JSON document.

The LIKE operation is a logical operation that tests whether a string matches a specified pattern.

The MEDIAN() function is a useful tool for calculating the median value of a set of numbers.