MySQL Function Reference — SQL Academy

String functions

BIT_LENGTH CHAR CHAR_LENGTH CONCAT CONCAT_WS INSTR LCASE LEFT LENGTH LOCATE LOWER LPAD LTRIM MID OCTET_LENGTH REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SUBSTR SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER

Numeric functions

ABS CEIL CEILING CONV COS DIV EXP FLOOR FORMAT GREATEST LEAST LOG MOD PI POW RAND ROUND SIGN SIN SQRT TAN TRUNCATE

Aggregate functions

ANY_VALUE AVG COUNT GROUP_CONCAT MAX MIN STDDEV STDDEV_POP STDDEV_SAMP SUM VAR_POP VAR_SAMP VARIANCE

Window functions

CUME_DIST DENSE_RANK FIRST_VALUE LAG LAST_VALUE LEAD NTH_VALUE NTILE PERCENT_RANK RANK ROW_NUMBER

Regular expression functions

REGEXP_INSTR REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR

Conditions and constructs

CASE CAST COALESCE CONVERT IF IFNULL ISNULL JSON_EXTRACT NULLIF WITH