> 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/secondary-functions.md).

# Secondary Functions

{% columns %}
{% column %}
{% content-ref url="/pages/xHzRDMWTi9tRbr4ZQn0W" %}
[Bit Functions and Operators](/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Perform bitwise logic and manipulation. This section covers operators like AND, OR, XOR, and functions for shifting bits or counting set bits in binary data.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/aaH3gSxX2WVU9VoQ8rpV" %}
[Encryption, Hashing and Compression Functions](/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about encryption, hashing, and compression functions. This section details SQL functions for securing data, generating hashes, and compressing/decompressing information within your database.
{% endcolumn %}
{% endcolumns %}

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

{% column %}
Retrieve system and session metadata. This section details functions to access database names, user details, version info, and query statistics like row counts.
{% endcolumn %}
{% endcolumns %}

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

{% column %}
Explore specialized utilities. This category includes functions for benchmarking, managing UUIDs, converting IP addresses, and handling binary data formats.
{% endcolumn %}
{% endcolumns %}