> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-functions.md).

# SQL Functions

{% columns %}
{% column %}
{% content-ref url="/pages/7ksdNeTA3sHLetBiupK3" %}
[Functions & Operators](/docs/server/reference/sql-functions/function-and-operator-reference.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Comprehensive reference of all SQL functions and operators. This index lists built-in functions for string manipulation, math, date/time, and more.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/K2sgped7fg0xalsc3XDd" %}
[Aggregate Functions](/docs/server/reference/sql-functions/aggregate-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Perform calculations on multiple rows to return a single value. Includes standard SQL functions like SUM, AVG, COUNT, MIN, and MAX, often used with GROUP BY.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/A8xcCgQ92IjqKsHpIhmr" %}
[Control Flow Functions](/docs/server/reference/sql-functions/control-flow-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about control flow functions in MariaDB Server. This section details SQL functions like IF, CASE, and NULLIF, which enable conditional logic within your queries and stored routines.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/c0gZZtKT3k1rwYVkE2lY" %}
[Date & Time Functions](/docs/server/reference/sql-functions/date-time-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete MariaDB date and time functions guide. Complete reference for formatting, calculations, conversions, time zones, and operations for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/adPADz83jb142u8RsbdA" %}
[Numeric Functions](/docs/server/reference/sql-functions/numeric-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about numeric functions in MariaDB Server. This section details SQL functions for performing mathematical calculations, rounding, and manipulating numeric values in your queries.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/W6xbAayUQ7L7QlzalPox" %}
[Pseudo Columns](/docs/server/reference/sql-functions/pseudo-columns.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
MariaDB has pseudo columns that can be used for different purposes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/T267OYHyMl7OoLnEg79h" %}
[Secondary Functions](/docs/server/reference/sql-functions/secondary-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore secondary functions in MariaDB Server. This section details various SQL functions that support specialized operations, enhancing data manipulation and analysis beyond core functionalities.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/3UB1P6bvRbEE7YvSOoYQ" %}
[Special Functions](/docs/server/reference/sql-functions/special-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore special functions in MariaDB Server. This section details unique SQL functions that provide specialized capabilities, often related to server internals, diagnostics, or specific data handling.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/wfy63s0KSq0qBcg8LN6m" %}
[String Functions](/docs/server/reference/sql-functions/string-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about string functions in MariaDB Server. This section details SQL functions for manipulating, searching, and formatting text strings, essential for data cleansing and presentation.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/MA5QSsusb0UAVFwoeEFK" %}
[Vector Functions](/docs/server/reference/sql-functions/vector-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore vector functions. This section details SQL functions for manipulating and querying vector data types, enabling efficient similarity search and AI/ML applications within your database.
{% endcolumn %}
{% endcolumns %}