Built-in Functions

• Function and Operator Reference

  A complete list of MariaDB functions and operators in alphabetical order.
• String Functions

  Built-In functions for the handling of strings and columns containing string values.
• Date & Time Functions

  Built-In functions for the handling of dates and times.
• Aggregate Functions

  Aggregate functions used with GROUP BY clauses.
• Numeric Functions

  Numeric and arithmetic related functions in MariaDB.
• Control Flow Functions

  Built-In functions for assessing data to determine what results to return.
• Pseudo Columns

  MariaDB has pseudo columns that can be used for different purposes.

Secondary Functions

• Bit Functions and Operators

  Operators for comparison and setting of values, and related functions.
• Encryption, Hashing and Compression Functions

  Functions used for encryption, hashing and compression.
• Information Functions

  Functions which return information on the server, the user, or a given query.
• Miscellaneous Functions

  Functions for very singular and specific needs.

Special Functions

• Dynamic Columns Functions

  Functions for storing key/value pairs of data within a column.
• Galera Functions

  Built-in functions related to Galera.
• Geographic Functions

  Geographic, as well as geometric functions.
• JSON Functions

  Built-in functions related to JSON.
• SEQUENCE Functions

  under: » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » Sequences
  Functions that can be used on SEQUENCEs.
• Spider Functions

  under: » MariaDB Server Documentation » Columns, Storage Engines, and Plugins » Storage Engines » Spider
  User-defined functions available with the Spider storage engine.
• Vector Functions

  under: » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » Vectors
  Built-in functions related to Vectors.
• Window Functions

  Window functions for performing calculations on a set of rows related to the current row.