Articles

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

How the COUNT() function works in Mariadb?

The MariaDB COUNT() function is used to count the number of rows that match a specified condition or retrieve the number of non-NULL values in a particular column.

How the FIND_IN_SET() function works in Mariadb?

The FIND_IN_SET() function is a string function that returns the position of a string in a comma-separated list of strings.

How the GREATEST() function works in Mariadb?

The GREATEST() function is a comparison function that returns the greatest value among a list of values.

How the COUNT(DISTINCT) function works in Mariadb?

The MariaDB COUNT(DISTINCT) function is used to return the count of distinct non-NULL values in a set.

How the FIELD() function works in Mariadb?

The MariaDB FIELD() function is used to return the index position of a string within a list of strings.

How the GLENGTH() function works in Mariadb?

The MariaDB GLENGTH() function is used to return the length of a lstring in units of its spatial reference.

How the COT() function works in Mariadb?

The COT() function is a mathematical function that returns the cotangent of a given angle. The function returns a decimal value that represents the cotangent of the angle in radians.

How the EXTRACTVALUE() function works in Mariadb?

The EXTRACTVALUE() function is an XML function that extracts a value from an XML document using an XPath expression.

How the COS() function works in Mariadb?

The COS() function is a mathematical function that returns the cosine of a given angle. The function returns a decimal value between -1 and 1, representing the cosine of the angle in radians.

How the EXTRACT() function works in Mariadb?

The EXTRACT() function is a date and time function that extracts a specific part of a date or time value.