MariaDB Database

  1. Built-in Functions
    1. String Functions
      1. Concatenation Functions
        1. CONCAT()
          1. CONCAT_WS()
          2. Substring Functions
            1. SUBSTRING()
              1. LEFT()
                1. RIGHT()
                2. String Length Functions
                  1. LENGTH()
                    1. CHAR_LENGTH()
                    2. Case Conversion Functions
                      1. UPPER()
                        1. LOWER()
                        2. Pattern Matching Functions
                          1. REGEXP
                            1. LIKE
                            2. Trimming and Padding Functions
                              1. TRIM()
                                1. LTRIM()
                                  1. RTRIM()
                                    1. LPAD()
                                      1. RPAD()
                                    2. Numeric Functions
                                      1. Rounding Functions
                                        1. ROUND()
                                          1. CEIL()
                                            1. FLOOR()
                                            2. Absolute Value Functions
                                              1. ABS()
                                              2. Mathematical Functions
                                                1. POWER()
                                                  1. SQRT()
                                                    1. MOD()
                                                    2. Random Number Generation
                                                      1. RAND()
                                                    3. Date and Time Functions
                                                      1. Date Extraction Functions
                                                        1. YEAR()
                                                          1. MONTH()
                                                            1. DAY()
                                                              1. HOUR()
                                                                1. MINUTE()
                                                                  1. SECOND()
                                                                  2. Date Arithmetic Functions
                                                                    1. DATE_ADD()
                                                                      1. DATE_SUB()
                                                                        1. DATEDIFF()
                                                                        2. Formatting Dates and Times
                                                                          1. DATE_FORMAT()
                                                                            1. TIME_FORMAT()
                                                                            2. Current Date and Time Functions
                                                                              1. NOW()
                                                                                1. CURDATE()
                                                                                  1. CURTIME()
                                                                                2. Control Flow Functions
                                                                                  1. CASE
                                                                                    1. IF
                                                                                      1. IFNULL
                                                                                        1. NULLIF
                                                                                        2. Type Casting Functions
                                                                                          1. CAST
                                                                                            1. CONVERT
                                                                                            2. JSON Functions
                                                                                              1. Extracting JSON Values
                                                                                                1. JSON_EXTRACT()
                                                                                                  1. JSON_VALUE()
                                                                                                  2. Modifying JSON Documents
                                                                                                    1. JSON_SET()
                                                                                                      1. JSON_INSERT()
                                                                                                        1. JSON_REPLACE()
                                                                                                        2. Searching within JSON
                                                                                                          1. JSON_CONTAINS()
                                                                                                        3. System Information Functions
                                                                                                          1. User and Connection Information
                                                                                                            1. USER()
                                                                                                              1. CONNECTION_ID()
                                                                                                              2. Database and Table Metadata
                                                                                                                1. DATABASE()
                                                                                                                  1. VERSION()
                                                                                                                  2. Server Status Functions
                                                                                                                    1. LAST_INSERT_ID()
                                                                                                                      1. ROW_COUNT()

                                                                                                                  Previous

                                                                                                                  5. Advanced Querying

                                                                                                                  Go to top

                                                                                                                  Next

                                                                                                                  7. Advanced MariaDB Features