SQL Function Reference

String functions

CHAR CONCAT INSTR LEFT LENGTH LOCATE LOWER LPAD LTRIM REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SUBSTRING TRIM UPPER

Numeric functions

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

Date and time functions

ADDDATE CURDATE CURTIME DATE DATE_FORMAT DATEDIFF DAY DAYNAME DAYOFWEEK HOUR MINUTE MONTH MONTHNAME NOW STR_TO_DATE SUBDATE TIMEDIFF TIMESTAMPADD TIMESTAMPDIFF YEAR

Advanced functions

CAST COALESCE IF IFNULL ISNULL NULLIF WITH

Window functions

DENSE_RANK FIRST_VALUE LAG LAST_VALUE LEAD RANK ROW_NUMBER