totn MySQL Functions

MySQL: Functions - Listed by Category

For easy reference, we have provided a list of all MySQL functions. The list of MySQL functions is sorted into the type of function based on categories such as string, advanced, numeric/mathematical, date/time, and encryption/compression functions.

These functions can be used in SQL statements or queries in MySQL. Or, they can be used within the programming environment provided by the MySQL database, such as stored procedures, functions, triggers, etc.

Below is the list of MySQL functions, sorted by category (ie: type of function).

String Functions

ASCII CHAR_LENGTH CHARACTER_LENGTH CONCAT CONCAT_WS FIELD FIND_IN_SET FORMAT INSERT INSTR LCASE
LEFT LENGTH LOCATE LOWER LPAD LTRIM MID POSITION REPEAT REPLACE REVERSE
RIGHT RPAD RTRIM SPACE STRCMP SUBSTR SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER

Numeric/Math Functions

ABS ACOS ASIN ATAN ATAN2 AVG CEIL CEILING COS COT COUNT DEGREES
DIV EXP FLOOR GREATEST LEAST LN LOG LOG10 LOG2 MAX MIN MOD
PI POW POWER RADIANS RAND ROUND SIGN SIN SQRT SUM TAN TRUNCATE

Date/Time Functions

ADDDATE ADDTIME CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATE DATE_ADD DATE_FORMAT DATE_SUB DATEDIFF DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR
EXTRACT FROM_DAYS 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 TIME_FORMAT TIME_TO_SEC TIMEDIFF TIMESTAMP TO_DAYS WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK

Advanced Functions

BIN BINARY CASE CAST COALESCE CONNECTION_ID CONV
CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID
NULLIF SESSION_USER SYSTEM_USER USER VERSION

Encryption Functions

ENCRYPT MD5
OLD_PASSWORD PASSWORD
Share on: