Functions in 10.5 ES¶

MariaDB Enterprise Server includes built-in functions to perform common programming tasks, such as working with strings, numbers, geometric data, temporal data; Regular Expression (regex) matching; and other data manipulation tasks performed on query result-sets.

Function

ABS()

ACOS()

ADDDATE()

ADDTIME()

AES_DECRYPT()

AES_ENCRYPT()

AREA()

ASBINARY()

ASCII()

ASIN()

ASTEXT()

ASWKB()

ASWKT()

ATAN()

ATAN2()

AVG()

BENCHMARK()

BIN()

BINLOG_GTID_POS()

BIT_AND()

BIT_COUNT()

BIT_LENGTH()

BIT_OR()

BIT_XOR()

BOUNDARY()

BUFFER()

CAST()

CEIL()

CEILING()

CENTROID()

CHAR()

CHAR_LENGTH()

CHARACTER_LENGTH()

CHARSET()

CHR()

COALESCE()

COERCIBILITY()

COLLATION()

COLUMN_ADD()

COLUMN_CHECK()

COLUMN_CREATE()

COLUMN_DELETE()

COLUMN_EXISTS()

COLUMN_GET()

COLUMN_JSON()

COLUMN_LIST()

COMPRESS()

CONCAT()

CONCAT_OPERATOR_ORACLE()

CONCAT_WS()

CONNECTION_ID()

CONTAINS()

CONV()

CONVERT()

CONVERT_TZ()

CONVEXHULL()

COS()

COT()

COUNT()

CRC32()

CROSSES()

CUME_DIST()

CURDATE()

CURRENT_DATE()

CURRENT_ROLE()

CURRENT_TIME()

CURRENT_TIMESTAMP()

CURRENT_USER()

CURTIME()

DATABASE()

DATE()

DATE_ADD()

DATE_FORMAT()

DATE_SUB()

DATEDIFF()

DAY()

DAYNAME()

DAYOFMONTH()

DAYOFWEEK()

DAYOFYEAR()

DECODE()

DECODE_HISTOGRAM()

DECODE_ORACLE()

DEFAULT()

DEGREES()

DENSE_RANK()

DES_DECRYPT()

DES_ENCRYPT()

DIMENSION()

DISJOINT()

ELT()

ENCODE()

ENCRYPT()

ENDPOINT()

ENVELOPE()

EQUALS()

EXP()

EXPORT_SET()

EXTERIORRING()

EXTRACT()

EXTRACTVALUE()

FIELD()

FIND_IN_SET()

FIRST_VALUE()

FLOOR()

FORMAT()

FOUND_ROWS()

FROM_BASE64()

FROM_DAYS()

FROM_UNIXTIME()

GEOMCOLLFROMTEXT()

GEOMCOLLFROMWKB()

GEOMETRYCOLLECTION()

GEOMETRYCOLLECTIONFROMTEXT()

GEOMETRYCOLLECTIONFROMWKB()

GEOMETRYFROMTEXT()

GEOMETRYFROMWKB()

GEOMETRYN()

GEOMETRYTYPE()

GEOMFROMTEXT()

GEOMFROMWKB()

GET_FORMAT()

GET_LOCK()

GLENGTH()

GREATEST()

GROUP_CONCAT()

HEX()

HOUR()

IF()

IFNULL()

INET6_ATON()

INET6_NTOA()

INET_ATON()

INET_NTOA()

INSERT()

INSTR()

INTERIORRINGN()

INTERSECTS()

INTERVAL()

IS_FREE_LOCK()

IS_IPV4()

IS_IPV4_COMPAT()

IS_IPV4_MAPPED()

IS_IPV6()

IS_USED_LOCK()

ISCLOSED()

ISEMPTY()

ISNULL()

ISRING()

ISSIMPLE()

JSON_ARRAY()

JSON_ARRAY_APPEND()

JSON_ARRAY_INSERT()

JSON_ARRAYAGG()

JSON_COMPACT()

JSON_CONTAINS()

JSON_CONTAINS_PATH()

JSON_DEPTH()

JSON_DETAILED()

JSON_EXISTS()

JSON_EXTRACT()

JSON_INSERT()

JSON_KEYS()

JSON_LENGTH()

JSON_LOOSE()

JSON_MERGE()

JSON_MERGE_PATCH()

JSON_MERGE_PRESERVE()

JSON_OBJECT()

JSON_OBJECTAGG()

JSON_QUERY()

JSON_QUOTE()

JSON_REMOVE()

JSON_REPLACE()

JSON_SEARCH()

JSON_SET()

JSON_TYPE()

JSON_UNQUOTE()

JSON_VALID()

JSON_VALUE()

LAG()

LAST_DAY()

LAST_INSERT_ID()

LAST_VALUE()

LCASE()

LEAD()

LEAST()

LEFT()

LENGTH()

LENGTHB()

LINEFROMTEXT()

LINEFROMWKB()

LINESTRING()

LINESTRINGFROMTEXT()

LINESTRINGFROMWKB()

LN()

LOAD_FILE()

LOCALTIME()

LOCALTIMESTAMP()

LOCATE()

LOG()

LOG2()

LOG10()

LOWER()

LPAD()

LPAD_ORACLE()

LTRIM()

LTRIM_ORACLE()

MAKE_SET()

MAKEDATE()

MAKETIME()

MASTER_GTID_WAIT()

MASTER_POS_WAIT()

MAX()

MBRCONTAINS()

MBRDISJOINT()

MBREQUAL()

MBREQUALS()

MBRINTERSECTS()

MBROVERLAPS()

MBRTOUCHES()

MBRWITHIN()

MD5()

MEDIAN()

MICROSECOND()

MID()

MIN()

MINUTE()

MLINEFROMTEXT()

MLINEFROMWKB()

MOD()

MONTH()

MONTHNAME()

MPOINTFROMTEXT()

MPOINTFROMWKB()

MPOLYFROMTEXT()

MPOLYFROMWKB()

MULTILINESTRING()

MULTILINESTRINGFROMTEXT()

MULTILINESTRINGFROMWKB()

MULTIPOINT()

MULTIPOINTFROMTEXT()

MULTIPOINTFROMWKB()

MULTIPOLYGON()

MULTIPOLYGONFROMTEXT()

MULTIPOLYGONFROMWKB()

NAME_CONST()

NEXTVAL()

NOW()

NTH_VALUE()

NTILE()

NULLIF()

NUMGEOMETRIES()

NUMINTERIORRINGS()

NUMPOINTS()

NVL()

NVL2()

OCT()

OCTET_LENGTH()

OLD_PASSWORD()

ORD()

OVERLAPS()

PASSWORD()

PERCENT_RANK()

PERCENTILE_CONT()

PERCENTILE_DISC()

PERIOD_ADD()

PERIOD_DIFF()

PI()

POINT()

POINTFROMTEXT()

POINTFROMWKB()

POINTN()

POINTONSURFACE()

POLYFROMTEXT()

POLYFROMWKB()

POLYGON()

POLYGONFROMTEXT()

POLYGONFROMWKB()

POSITION()

POW()

POWER()

QUARTER()

QUOTE()

RADIANS()

RAND()

RANK()

REGEXP_INSTR()

REGEXP_REPLACE()

REGEXP_SUBSTR()

RELEASE_LOCK()

REPEAT()

REPLACE()

REVERSE()

RIGHT()

ROUND()

ROW_COUNT()

ROW_NUMBER()

RPAD()

RPAD_ORACLE()

RTRIM()

RTRIM_ORACLE()

SCHEMA()

SEC_TO_TIME()

SECOND()

SESSION_USER()

SETVAL()

SHA()

SHA1()

SHA2()

SIGN()

SIN()

SLEEP()

SOUNDEX()

SPACE()

SPIDER_BG_DIRECT_SQL()

SPIDER_COPY_TABLES()

SPIDER_DIRECT_SQL()

SPIDER_FLUSH_TABLE_MON_CACHE()

SQRT()

SRID()

ST_AREA()

ST_ASBINARY()

ST_ASGEOJSON()

ST_ASTEXT()

ST_ASWKB()

ST_ASWKT()

ST_BOUNDARY()

ST_BUFFER()

ST_CENTROID()

ST_CONTAINS()

ST_CONVEXHULL()

ST_CROSSES()

ST_DIFFERENCE()

ST_DIMENSION()

ST_DISJOINT()

ST_DISTANCE()

ST_ENDPOINT()

ST_ENVELOPE()

ST_EQUALS()

ST_EXTERIORRING()

ST_GEOMCOLLFROMTEXT()

ST_GEOMCOLLFROMWKB()

ST_GEOMETRYCOLLECTIONFROMTEXT()

ST_GEOMETRYCOLLECTIONFROMWKB()

ST_GEOMETRYFROMTEXT()

ST_GEOMETRYFROMWKB()

ST_GEOMETRYN()

ST_GEOMETRYTYPE()

ST_GEOMFROMGEOJSON()

ST_GEOMFROMTEXT()

ST_GEOMFROMWKB()

ST_INTERIORRINGN()

ST_INTERSECTION()

ST_INTERSECTS()

ST_ISCLOSED()

ST_ISEMPTY()

ST_ISRING()

ST_ISSIMPLE()

ST_LENGTH()

ST_LINEFROMTEXT()

ST_LINEFROMWKB()

ST_LINESTRINGFROMTEXT()

ST_LINESTRINGFROMWKB()

ST_MLINEFROMTEXT()

ST_MLINEFROMWKB()

ST_MPOINTFROMTEXT()

ST_MPOINTFROMWKB()

ST_MPOLYFROMTEXT()

ST_MPOLYFROMWKB()

ST_MULTILINESTRINGFROMTEXT()

ST_MULTILINESTRINGFROMWKB()

ST_MULTIPOINTFROMTEXT()

ST_MULTIPOINTFROMWKB()

ST_MULTIPOLYGONFROMTEXT()

ST_MULTIPOLYGONFROMWKB()

ST_NUMGEOMETRIES()

ST_NUMINTERIORRINGS()

ST_NUMPOINTS()

ST_OVERLAPS()

ST_POINTFROMTEXT()

ST_POINTFROMWKB()

ST_POINTN()

ST_POINTONSURFACE()

ST_POLYFROMTEXT()

ST_POLYFROMWKB()

ST_POLYGONFROMTEXT()

ST_POLYGONFROMWKB()

ST_RELATE()

ST_SRID()

ST_STARTPOINT()

ST_SYMDIFFERENCE()

ST_TOUCHES()

ST_UNION()

ST_WITHIN()

ST_X()

ST_Y()

STARTPOINT()

STD()

STDDEV()

STDDEV_POP()

STDDEV_SAMP()

STR_TO_DATE()

STRCMP()

SUBDATE()

SUBSTR()

SUBSTRING()

SUBSTRING_INDEX()

SUBTIME()

SUM()

SYSDATE()

SYSTEM_USER()

TAN()

TIME()

TIME_FORMAT()

TIME_TO_SEC()

TIMEDIFF()

TIMESTAMP()

TIMESTAMPADD()

TIMESTAMPDIFF()

TO_BASE64()

TO_DAYS()

TO_SECONDS()

TOUCHES()

TRIM()

TRIM_ORACLE()

TRUNCATE()

UCASE()

UNCOMPRESS()

UNCOMPRESSED_LENGTH()

UNHEX()

UNIX_TIMESTAMP()

UPDATEXML()

UPPER()

USER()

UTC_DATE()

UTC_TIME()

UTC_TIMESTAMP()

UUID()

UUID_SHORT()

VALUE()

VALUES()

VAR_POP()

VAR_SAMP()

VARIANCE()

VERSION()

WEEK()

WEEKDAY()

WEEKOFYEAR()

WEIGHT_STRING()

WITHIN()

WSREP_LAST_SEEN_GTID()

WSREP_LAST_WRITTEN_GTID()

WSREP_SYNC_WAIT_UPTO_GTID()

X()

Y()

YEAR()

YEARWEEK()