MySQL Reference
This page arranges the materials related to learning and using MySQL.
To reformat a MySQL query in your browser, use the SQL formatter. The MySQL dialect is selected for you; the query stays in your browser and formatting does not execute or validate it.
-
MySQL String Functions
- ASCII
- BIN
- BIT_LENGTH
- CHAR
- CHAR_LENGTH
- CHARACTER_LENGTH
- CONCAT
- CONCAT_WS
- ELT
- EXPORT_SET
- FIELD
- FIND_IN_SET
- FORMAT
- FROM_BASE64
- HEX
- INSERT
- INSTR
- LCASE
- LEFT
- LENGTH
- LOCATE
- LOWER
- LPAD
- LTRIM
- MAKE_SET
- MID
- OCT
- OCTET_LENGTH
- ORD
- POSITION
- QUOTE
- REPEAT
- REPLACE
- REVERSE
- RIGHT
- RPAD
- RTRIM
- SOUNDEX
- SPACE
- STRCMP
- SUBSTR
- SUBSTRING
- SUBSTRING_INDEX
- TO_BASE64
- TRIM
- UCASE
- UNHEX
- UPPER
-
MySQL Math Functions
-
MySQL Date and Time Functions
- 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
- FROM_DAYS
- FROM_UNIXTIME
- GET_FORMAT
- 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
- TIMESTAMPADD
- TIMESTAMPDIFF
- TO_DAYS
- TO_SECONDS
- UNIX_TIMESTAMP
- UTC_DATE
- UTC_TIME
- UTC_TIMESTAMP
- WEEK
- WEEKDAY
- WEEKOFYEAR
- YEAR
- YEARWEEK
-
MySQL Regular Expression Functions
-
MySQL JSON Functions
- JSON_ARRAY
- JSON_ARRAY_APPEND
- JSON_ARRAY_INSERT
- JSON_CONTAINS
- JSON_CONTAINS_PATH
- JSON_DEPTH
- JSON_EXTRACT
- JSON_INSERT
- JSON_KEYS
- JSON_LENGTH
- JSON_MERGE
- JSON_MERGE_PATCH
- JSON_MERGE_PRESERVE
- JSON_OBJECT
- JSON_OVERLAPS
- JSON_PRETTY
- JSON_QUOTE
- JSON_REMOVE
- JSON_REPLACE
- JSON_SCHEMA_VALID
- JSON_SCHEMA_VALIDATION_REPORT
- JSON_SEARCH
- JSON_SET
- JSON_STORAGE_FREE
- JSON_STORAGE_SIZE
- JSON_TABLE
- JSON_TYPE
- JSON_UNQUOTE
- JSON_VALID
- JSON_VALUE
- MEMBER OF
-
MySQL Aggregate Functions
-
MySQL Other Functions
-
MySQL Data Types Reference
-
MySQL Information Functions
-
MySQL Window Functions