Mysql has many inbuilt MySQL functions. Those MySQL Functions can be used in SQL statements or queries in MySQL.
On the basis of their uses we can categorize them into the following categories and also I am putting some MySQL Functions related to relevant categories:-
1. MySQL String Function:-
ASCII, CHAR, CHAR_LENGTH, CHARACTER_LENGTH, COERCIBILITY, COLLATION, COMPRESS, CONCAT, CONCAT_WS, ELT, EXPORT_SET, ExtractValue, FIELD, FIND_IN_SET, FORMAT, GROUP_CONCAT, INSERT, INSTR, LCASE, LEFT, LENGTH, LOCATE, LOWER, LPAD, LTRIM, LineString, MAKE_SET, MATCH, MID, MultiLineString, POSITION, REPEAT, REPLACE, REVERSE, RIGHT, RPAD, RTRIM, SPACE, STRCMP, SUBSTR, SUBSTRING, SUBSTRING_INDEX, TRIM, UCASE, UPPER
2. MySQL Numeric or Mathematical Function:- ABS, ACOS, ASIN, ATAN, ATAN2, AVG, CEIL, CEILING, COS, COT, COUNT, CUME_DIST, DEGREES, DIV, EXP, FLOOR, FORMAT, FORMAT_BYTES, GeomCollection, GeometryCollection, GREATEST, LEAST, LN, LOG, LOG10, LOG2, MAX, MIN, MOD, PI, POW, POWER, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, SUM, TAN, TRUNCATE
3. MySQL Date or Time Function:- ADDDATE, ADDTIME, CONVERT_TZ, CURDATE, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURTIME, DATE, DATE_ADD, DATE_FORMAT, DATE_SUB, DATEDIFF, DAY, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, EXTRACT, FORMAT_PICO_TIME, FROM_DAYS, FROM_UNIXTIME, 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
4. MySQL Advanced Function:- ANY_VALUE, BENCHMARK, BIN, BIN_TO_UUID, BINARY, BIT_AND, BIT_COUNT, BIT_LENGTH, BIT_OR, BIT_XOR, CAN_ACCESS_COLUMN, CAN_ACCESS_DATABASE, CAN_ACCESS_TABLE, CAN_ACCESS_USER, CAN_ACCESS_VIEW, CASE, CAST, CHARSET, COALESCE, CONNECTION_ID, CONV, CONVERT, CURRENT_ROLE, CURRENT_USER, DATABASE, DEFAULT , DENSE_RANK , FIRST_VALUE , FOUND_ROWS, GET_DD_COLUMN_PRIVILEGES, GET_DD_CREATE_OPTIONS, GET_DD_INDEX_SUB_PART_LENGTH, GET_LOCK , GROUPING, GTID_SUBSET, GTID_SUBTRACT, HEX, ICU_VERSION, IF, IFNULL, IN, INET_ATON, INET_NTOA,INET6_ATON,INET6_NTOA, INTERNAL_AUTO_INCREMENT, INTERNAL_AVG_ROW_LENGTH, INTERVALLAST_INSERT_ID, LAST_VALUE, LEAD, LEAST, LOAD_FILE, MASTER_POS_WAIT. IF, IFNULL, ISNULL, LAST_INSERT_ID, NULLIF, SESSION_USER, SYSTEM_USER, USER, VERSION
5.MySQL Encryption or Compression Function:- AES_DECRYPT, AES_ENCRYPT, CRC32, ENCRYPT, FROM_BASE64 , MD5, OLD_PASSWORD, PASSWORD.
Read Also:-
MySQL String Functions
MySQL Numeric or Mathematical Function
MySQL Date Or Time Function
MySQL Advanced Function
MySQL Encryption or Compression Function
For more detail about the function you may read MySQL manual
