MariaDB: Functions

https://www.techonthenet.com/mariadb/functions/index.php

MariaDB: Functions - Listed by Category

For easy reference, we have provided a list of all MariaDB functions. The list of MariaDB functions is sorted into the type of function based on categories such as string, advanced, numeric/mathematical, date/time, and encryption/compression functions.

These functions can be used in SQL statements or queries in MariaDB. Or, they can be used within the programming environment provided by the MariaDB database, such as stored procedures, functions, triggers, etc.

Below is the list of MariaDB functions, sorted by category (ie: type of function).

String Functions

ASCIICHAR_LENGTHCHARACTER_LENGTHCONCATCONCAT_WSFIELDFIND_IN_SETFORMATINSERTINSTRLCASELEFTLENGTH

LOCATELOWERLPADLTRIMMIDPOSITIONREGEXPREGEXP_INSTRREGEXP_REPLACEREGEXP_SUBSTRREPEATREPLACEREVERSE

RIGHTRPADRTRIMSPACESTRCMPSUBSTRSUBSTRINGSUBSTRING_INDEXTRIMUCASEUPPER

Numeric/Math Functions

ABSACOSASINATANATAN2AVGCEILCEILINGCOSCOTCOUNTDEGREES

DIVEXPFLOORGREATESTLEASTLNLOGLOG10LOG2MAXMINMOD

PIPOWPOWERRADIANSRANDROUNDSIGNSINSQRTSUMTANTRUNCATE

Date/Time Functions

ADDDATEADDTIMECURDATECURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPCURTIMEDATEDATE_ADDDATE_FORMATDATE_SUBDATEDIFFDAYDAYNAMEDAYOFMONTHDAYOFWEEKDAYOFYEAR

EXTRACTFROM_DAYSHOURLAST_DAYLOCALTIMELOCALTIMESTAMPMAKEDATEMAKETIMEMICROSECONDMINUTEMONTHMONTHNAMENOWPERIOD_ADDPERIOD_DIFFQUARTERSEC_TO_TIME

SECONDSTR_TO_DATESUBDATESUBTIMESYSDATETIMETIME_FORMATTIME_TO_SECTIMEDIFFTIMESTAMPTO_DAYSWEEKWEEKDAYWEEKOFYEARYEARYEARWEEK

Advanced Functions

BINBINARYCASECASTCOALESCECONNECTION_IDCONV

CONVERTCURRENT_USERDATABASEIFIFNULLISNULLLAST_INSERT_ID

NULLIFSESSION_USERSYSTEM_USERUSERVERSION

Encryption Functions

ENCRYPTMD5

OLD_PASSWORDPASSWORD