MariaDB
Function Reference
Every MariaDB function. Real examples. MySQL differences noted. Anti-patterns called out. Built for developers who need answers fast.
Try: · · ·
Browse by Category
10 categoriesString Functions
71 functions
Numeric Functions
34 functions
Date & Time Functions
65 functions
Aggregate Functions
16 functions
Window Functions
13 functions
JSON Functions
40 functions
Control Flow
9 functions
System & Info
22 functions
Encryption & Security
17 functions
Miscellaneous & Network
24 functions
Frequently Reached For
GROUP_CONCAT()Concatenate grouped values into a string
DATE_FORMAT()Format a date/time value as a string
JSON_EXTRACT()Extract a value from a JSON document
COALESCE()Return first non-NULL value
REGEXP_REPLACE()Replace substrings matching a regex pattern
TIMESTAMPDIFF()Return difference between timestamps in given unit
About This Reference
This MariaDB function reference is part of pgref.dev, which also covers PostgreSQL and SQLite. Every function includes MySQL compatibility notes, making it ideal for developers migrating between MariaDB and MySQL or working with both simultaneously.
MariaDB is a community-developed fork of MySQL with additional features including better JSON support, window functions, Oracle compatibility modes, and the Aria storage engine. Functions that differ between MariaDB and MySQL are clearly flagged.
Key areas covered: string manipulation (CONCAT, REGEXP_REPLACE, SUBSTRING_INDEX), date and time functions (DATE_FORMAT, TIMESTAMPDIFF, STR_TO_DATE), JSON functions (JSON_EXTRACT, JSON_TABLE, JSON_ARRAYAGG), and window functions.
The Quirks & Gotchas page covers the most important MariaDB surprises: NULL propagation in CONCAT, SYSDATE vs NOW differences, case-insensitive collation defaults, and SQL mode effects.