MariaDB Reference
This page arranges the materials related to learning and using MariaDB.
-
MariaDB String Functions
- ASCII()
- BIN()
- BIT_LENGTH()
- CHAR_LENGTH()
- CHAR()
- CHARACTER_LENGTH()
- CHR()
- COMPRESS()
- CONCAT_WS()
- CONCAT()
- ELT()
- EXPORT_SET()
- FIELD()
- FIND_IN_SET()
- FORMAT()
- FROM_BASE64()
- HEX()
- INSERT()
- INSTR()
- LCASE()
- LEFT()
- LENGTH()
- LENGTHB()
- LOAD_FILE()
- LOCATE()
- LOWER()
- LPAD()
- LTRIM_ORACLE()
- LTRIM()
- MAKE_SET()
- MID()
- OCTET_LENGTH()
- ORD()
- POSITION()
- QUOTE()
- REGEXP_INSTR()
- REGEXP_REPLACE()
- REGEXP_SUBSTR()
- REPEAT()
- REPLACE()
- REVERSE()
- RIGHT()
- RPAD()
- RTRIM_ORACLE()
- RTRIM()
- SOUNDEX()
- SOUNDS LIKE
- SPACE()
- STRCMP()
- SUBSTR()
- SUBSTRING_INDEX()
- SUBSTRING()
- TO_BASE64()
- TO_CHAR()
- TRIM_ORACLE()
- TRIM()
- UCASE()
- UNCOMPRESS()
- UNCOMPRESSED_LENGTH()
- UNHEX()
- UPPER()
- WEIGHT_STRING()
-
MariaDB Math Functions
-
MariaDB Control Functions
-
MariaDB Data and Time Functions
- ADD_MONTHS()
- ADDDATE()
- ADDTIME()
- CONVERT_TZ()
- CURDATE()
- CURRENT_DATE()
- CURRENT_TIME()
- CURRENT_TIMESTAMP()
- CURTIME()
- DATE_ADD()
- DATE_FORMAT()
- DATE_SUB()
- DATE()
- DATEDIFF()
- DAY()
- DAYNAME()
- DAYOFMONTH()
- DAYOFWEEK()
- DAYOFYEAR()
- EXTRACT()
- FROM_DAYS()
- FROM_UNIXTIME()
- GET_FORMAT()
- HOUR()
- LAST_DAY
- LOCALTIME()
- LOCALTIMESTAMP()
- MAKEDATE()
- MAKETIME()
- MICROSECOND()
- MINUTE()
- MONTH()
- MONTHNAME()
- NOW()
- PERIOD_ADD()
- PERIOD_DIFF()
- QUARTER()
- SEC_TO_TIME()
- SECOND()
- STR_TO_DATE()
- SUBDATE()
- SUBTIME()
- SYSDATE()
- TIME_FORMAT()
- TIME_TO_SEC()
- TIME()
- TIMEDIFF()
- TIMESTAMP()
- TIMESTAMPADD()
- TIMESTAMPDIFF()
- TO_DAYS()
- TO_SECONDS()
- UNIX_TIMESTAMP()
- UTC_DATE()
- UTC_TIME()
- UTC_TIMESTAMP()
- WEEK()
- WEEKDAY()
- WEEKOFYEAR()
- YEAR()
- YEARWEEK()
-
MariaDB JSON Functions Reference
- JSON_ARRAY_APPEND()
- JSON_ARRAY_INSERT()
- JSON_ARRAY()
- JSON_ARRAYAGG()
- JSON_COMPACT()
- JSON_CONTAINS_PATH()
- JSON_CONTAINS()
- JSON_DEPTH()
- JSON_DETAILED()
- JSON_EXISTS()
- JSON_EXTRACT()
- JSON_INSERT()
- JSON_KEYS()
- JSON_LENGTH()
- JSON_LOOSE()
- JSON_MERGE_PATCH()
- JSON_MERGE_PRESERVE()
- JSON_MERGE()
- JSON_OBJECT()
- JSON_OBJECTAGG()
- JSON_QUERY()
- JSON_QUOTE()
- JSON_REMOVE()
- JSON_REPLACE()
- JSON_SEARCH()
- JSON_SET()
- JSON_TABLE()
- JSON_TYPE()
- JSON_UNQUOTE()
- JSON_VALID()
- JSON_VALUE()
-
MariaDB Aggreagte Functions
-
MariaDB Information Function
-
MariaDB Operators
-
MariaDB XML Functions
-
MariaDB Summary
-
MariaDB Data Types Reference