The following table shows all SQL functions and operators available across MySQL Server 5.6 through 8.0. The table contains these columns:
Name: The name of the function or operator.
Introduced: The version or versions in which the function or operator was introduced.
Deprecated: The version or versions in which the function or operator was deprecated.
Removed: The version or versions in which the function or operator was removed.
5.6, 5.7, and so forth: Whether the function or operator is available in each MySQL Server series. If more information is available in the main reference manual, the indication is a link to the correct part of the manual.
Table 2.1 SQL Operators/Functions Reference
Name | Introduced | Deprecated | Removed | 5.6 | 5.7 | 8.0 |
---|---|---|---|---|---|---|
& |
Yes | Yes | Yes | |||
> |
Yes | Yes | Yes | |||
>> |
Yes | Yes | Yes | |||
>= |
Yes | Yes | Yes | |||
< |
Yes | Yes | Yes | |||
<> , !=
|
Yes | Yes | Yes | |||
<< |
Yes | Yes | Yes | |||
<= |
Yes | Yes | Yes | |||
<=> |
Yes | Yes | Yes | |||
% , MOD
|
Yes | Yes | Yes | |||
* |
Yes | Yes | Yes | |||
+ |
Yes | Yes | Yes | |||
- |
Yes | Yes | Yes | |||
- |
Yes | Yes | Yes | |||
-> |
5.7.9 | Yes | Yes | |||
->> |
5.7.13 | Yes | Yes | |||
/ |
Yes | Yes | Yes | |||
:= |
Yes | Yes | Yes | |||
= |
Yes | Yes | Yes | |||
= |
Yes | Yes | Yes | |||
^ |
Yes | Yes | Yes | |||
ABS() |
Yes | Yes | Yes | |||
ACOS() |
Yes | Yes | Yes | |||
ADDDATE() |
Yes | Yes | Yes | |||
ADDTIME() |
Yes | Yes | Yes | |||
AES_DECRYPT() |
Yes | Yes | Yes | |||
AES_ENCRYPT() |
Yes | Yes | Yes | |||
AND , &&
|
Yes | Yes | Yes | |||
ANY_VALUE() |
5.7.5 | Yes | Yes | |||
Area() |
5.7.6 | Yes | Yes | |||
AsBinary() , AsWKB()
|
5.7.6 | Yes | Yes | |||
ASCII() |
Yes | Yes | Yes | |||
ASIN() |
Yes | Yes | Yes | |||
AsText() , AsWKT()
|
5.7.6 | Yes | Yes | |||
ATAN() |
Yes | Yes | Yes | |||
ATAN2() , ATAN()
|
Yes | Yes | Yes | |||
AVG() |
Yes | Yes | Yes | |||
BENCHMARK() |
Yes | Yes | Yes | |||
BETWEEN ... AND ... |
Yes | Yes | Yes | |||
BIN() |
Yes | Yes | Yes | |||
BIN_TO_UUID() |
Yes | |||||
BINARY |
Yes | Yes | Yes | |||
BIT_AND() |
Yes | Yes | Yes | |||
BIT_COUNT() |
Yes | Yes | Yes | |||
BIT_LENGTH() |
Yes | Yes | Yes | |||
BIT_OR() |
Yes | Yes | Yes | |||
BIT_XOR() |
Yes | Yes | Yes | |||
Buffer() |
5.6.1 | 5.7.6 | Yes | Yes | ||
CAN_ACCESS_COLUMN() |
Yes | |||||
CAN_ACCESS_DATABASE() |
Yes | |||||
CAN_ACCESS_TABLE() |
Yes | |||||
CAN_ACCESS_USER() |
8.0.22 | Yes | ||||
CAN_ACCESS_VIEW() |
Yes | |||||
CASE |
Yes | Yes | Yes | |||
CAST() |
Yes | Yes | Yes | |||
CEIL() |
Yes | Yes | Yes | |||
CEILING() |
Yes | Yes | Yes | |||
Centroid() |
5.7.6 | Yes | Yes | |||
CHAR() |
Yes | Yes | Yes | |||
CHAR_LENGTH() |
Yes | Yes | Yes | |||
CHARACTER_LENGTH() |
Yes | Yes | Yes | |||
CHARSET() |
Yes | Yes | Yes | |||
COALESCE() |
Yes | Yes | Yes | |||
COERCIBILITY() |
Yes | Yes | Yes | |||
COLLATION() |
Yes | Yes | Yes | |||
COMPRESS() |
Yes | Yes | Yes | |||
CONCAT() |
Yes | Yes | Yes | |||
CONCAT_WS() |
Yes | Yes | Yes | |||
CONNECTION_ID() |
Yes | Yes | Yes | |||
Contains() |
5.7.6 | Yes | Yes | |||
CONV() |
Yes | Yes | Yes | |||
CONVERT() |
Yes | Yes | Yes | |||
CONVERT_TZ() |
Yes | Yes | Yes | |||
ConvexHull() |
5.7.5 | 5.7.6 | Yes | |||
COS() |
Yes | Yes | Yes | |||
COT() |
Yes | Yes | Yes | |||
COUNT() |
Yes | Yes | Yes | |||
COUNT(DISTINCT) |
Yes | Yes | Yes | |||
CRC32() |
Yes | Yes | Yes | |||
Crosses() |
5.7.6 | Yes | Yes | |||
CUME_DIST() |
8.0.2 | Yes | ||||
CURDATE() |
Yes | Yes | Yes | |||
CURRENT_DATE() , CURRENT_DATE
|
Yes | Yes | Yes | |||
CURRENT_ROLE() |
Yes | |||||
CURRENT_TIME() , CURRENT_TIME
|
Yes | Yes | Yes | |||
CURRENT_TIMESTAMP() , CURRENT_TIMESTAMP
|
Yes | Yes | Yes | |||
CURRENT_USER() , CURRENT_USER
|
Yes | Yes | Yes | |||
CURTIME() |
Yes | Yes | Yes | |||
DATABASE() |
Yes | Yes | Yes | |||
DATE() |
Yes | Yes | Yes | |||
DATE_ADD() |
Yes | Yes | Yes | |||
DATE_FORMAT() |
Yes | Yes | Yes | |||
DATE_SUB() |
Yes | Yes | Yes | |||
DATEDIFF() |
Yes | Yes | Yes | |||
DAY() |
Yes | Yes | Yes | |||
DAYNAME() |
Yes | Yes | Yes | |||
DAYOFMONTH() |
Yes | Yes | Yes | |||
DAYOFWEEK() |
Yes | Yes | Yes | |||
DAYOFYEAR() |
Yes | Yes | Yes | |||
DECODE() |
5.7.2 | 8.0.3 | Yes | Yes | Yes | |
DEFAULT() |
Yes | Yes | Yes | |||
DEGREES() |
Yes | Yes | Yes | |||
DENSE_RANK() |
8.0.2 | Yes | ||||
DES_DECRYPT() |
5.7.6 | 8.0.3 | Yes | Yes | Yes | |
DES_ENCRYPT() |
5.7.6 | 8.0.3 | Yes | Yes | Yes | |
Dimension() |
5.7.6 | Yes | Yes | |||
Disjoint() |
5.7.6 | Yes | Yes | |||
Distance() |
5.7.5 | 5.7.6 | Yes | |||
DIV |
Yes | Yes | Yes | |||
ELT() |
Yes | Yes | Yes | |||
ENCODE() |
5.7.2 | 8.0.3 | Yes | Yes | Yes | |
ENCRYPT() |
5.7.6 | 8.0.3 | Yes | Yes | Yes | |
EndPoint() |
5.7.6 | Yes | Yes | |||
Envelope() |
5.7.6 | Yes | Yes | |||
Equals() |
5.7.6 | Yes | Yes | |||
EXP() |
Yes | Yes | Yes | |||
EXPORT_SET() |
Yes | Yes | Yes | |||
ExteriorRing() |
5.7.6 | Yes | Yes | |||
EXTRACT() |
Yes | Yes | Yes | |||
ExtractValue() |
Yes | Yes | Yes | |||
FIELD() |
Yes | Yes | Yes | |||
FIND_IN_SET() |
Yes | Yes | Yes | |||
FIRST_VALUE() |
8.0.2 | Yes | ||||
FLOOR() |
Yes | Yes | Yes | |||
FORMAT() |
Yes | Yes | Yes | |||
FORMAT_BYTES() |
8.0.16 | Yes | ||||
FORMAT_PICO_TIME() |
8.0.16 | Yes | ||||
FOUND_ROWS() |
Yes | Yes | Yes | |||
FROM_BASE64() |
5.6.1 | Yes | Yes | Yes | ||
FROM_DAYS() |
Yes | Yes | Yes | |||
FROM_UNIXTIME() |
Yes | Yes | Yes | |||
GeomCollection() |
8.0.11 | Yes | ||||
GeomCollFromText() , GeometryCollectionFromText()
|
5.7.6 | Yes | Yes | |||
GeomCollFromWKB() , GeometryCollectionFromWKB()
|
5.7.6 | Yes | Yes | |||
GeometryCollection() |
Yes | Yes | Yes | |||
GeometryN() |
5.7.6 | Yes | Yes | |||
GeometryType() |
5.7.6 | Yes | Yes | |||
GeomFromText() , GeometryFromText()
|
5.7.6 | Yes | Yes | |||
GeomFromWKB() , GeometryFromWKB()
|
5.7.6 | Yes | Yes | |||
GET_DD_COLUMN_PRIVILEGES() |
Yes | |||||
GET_DD_CREATE_OPTIONS() |
Yes | |||||
GET_DD_INDEX_SUB_PART_LENGTH() |
Yes | |||||
GET_FORMAT() |
Yes | Yes | Yes | |||
GET_LOCK() |
Yes | Yes | Yes | |||
GLength() |
5.7.6 | Yes | Yes | |||
GREATEST() |
Yes | Yes | Yes | |||
GROUP_CONCAT() |
Yes | Yes | Yes | |||
GROUPING() |
8.0.1 | Yes | ||||
GTID_SUBSET() |
5.6.5 | Yes | Yes | Yes | ||
GTID_SUBTRACT() |
5.6.5 | Yes | Yes | Yes | ||
HEX() |
Yes | Yes | Yes | |||
HOUR() |
Yes | Yes | Yes | |||
ICU_VERSION() |
8.0.4 | Yes | ||||
IF() |
Yes | Yes | Yes | |||
IFNULL() |
Yes | Yes | Yes | |||
IN() |
Yes | Yes | Yes | |||
INET_ATON() |
Yes | Yes | Yes | |||
INET_NTOA() |
Yes | Yes | Yes | |||
INET6_ATON() |
5.6.3 | Yes | Yes | Yes | ||
INET6_NTOA() |
5.6.3 | Yes | Yes | Yes | ||
INSERT() |
Yes | Yes | Yes | |||
INSTR() |
Yes | Yes | Yes | |||
InteriorRingN() |
5.7.6 | Yes | Yes | |||
INTERNAL_AUTO_INCREMENT() |
Yes | |||||
INTERNAL_AVG_ROW_LENGTH() |
Yes | |||||
INTERNAL_CHECK_TIME() |
Yes | |||||
INTERNAL_CHECKSUM() |
Yes | |||||
INTERNAL_DATA_FREE() |
Yes | |||||
INTERNAL_DATA_LENGTH() |
Yes | |||||
INTERNAL_DD_CHAR_LENGTH() |
Yes | |||||
INTERNAL_GET_COMMENT_OR_ERROR() |
Yes | |||||
INTERNAL_GET_ENABLED_ROLE_JSON() |
8.0.19 | Yes | ||||
INTERNAL_GET_HOSTNAME() |
8.0.19 | Yes | ||||
INTERNAL_GET_USERNAME() |
8.0.19 | Yes | ||||
INTERNAL_GET_VIEW_WARNING_OR_ERROR() |
Yes | |||||
INTERNAL_INDEX_COLUMN_CARDINALITY() |
Yes | |||||
INTERNAL_INDEX_LENGTH() |
Yes | |||||
INTERNAL_IS_ENABLED_ROLE() |
8.0.19 | Yes | ||||
INTERNAL_IS_MANDATORY_ROLE() |
8.0.19 | Yes | ||||
INTERNAL_KEYS_DISABLED() |
Yes | |||||
INTERNAL_MAX_DATA_LENGTH() |
Yes | |||||
INTERNAL_TABLE_ROWS() |
Yes | |||||
INTERNAL_UPDATE_TIME() |
Yes | |||||
Intersects() |
5.7.6 | Yes | Yes | |||
INTERVAL() |
Yes | Yes | Yes | |||
IS |
Yes | Yes | Yes | |||
IS_FREE_LOCK() |
Yes | Yes | Yes | |||
IS_IPV4() |
5.6.3 | Yes | Yes | Yes | ||
IS_IPV4_COMPAT() |
5.6.3 | Yes | Yes | Yes | ||
IS_IPV4_MAPPED() |
5.6.3 | Yes | Yes | Yes | ||
IS_IPV6() |
5.6.3 | Yes | Yes | Yes | ||
IS NOT |
Yes | Yes | Yes | |||
IS NOT NULL |
Yes | Yes | Yes | |||
IS NULL |
Yes | Yes | Yes | |||
IS_USED_LOCK() |
Yes | Yes | Yes | |||
IS_UUID() |
Yes | |||||
IsClosed() |
5.7.6 | Yes | Yes | |||
IsEmpty() |
5.7.6 | Yes | Yes | |||
ISNULL() |
Yes | Yes | Yes | |||
IsSimple() |
5.7.6 | Yes | Yes | |||
JSON_APPEND() |
5.7.8 | 5.7.9 | Yes | |||
JSON_ARRAY() |
5.7.8 | Yes | Yes | |||
JSON_ARRAY_APPEND() |
5.7.9 | Yes | Yes | |||
JSON_ARRAY_INSERT() |
5.7.8 | Yes | Yes | |||
JSON_ARRAYAGG() |
5.7.22, 8.0.1 | Yes | Yes | |||
JSON_CONTAINS() |
5.7.8 | Yes | Yes | |||
JSON_CONTAINS_PATH() |
5.7.8 | Yes | Yes | |||
JSON_DEPTH() |
5.7.8 | Yes | Yes | |||
JSON_EXTRACT() |
5.7.8 | Yes | Yes | |||
JSON_INSERT() |
5.7.8 | Yes | Yes | |||
JSON_KEYS() |
5.7.8 | Yes | Yes | |||
JSON_LENGTH() |
5.7.8 | Yes | Yes | |||
JSON_MERGE() |
5.7.8 | 5.7.22, 8.0.3 | Yes | Yes | ||
JSON_MERGE_PATCH() |
5.7.22, 8.0.3 | Yes | Yes | |||
JSON_MERGE_PRESERVE() |
5.7.22, 8.0.3 | Yes | Yes | |||
JSON_OBJECT() |
5.7.8 | Yes | Yes | |||
JSON_OBJECTAGG() |
5.7.22, 8.0.1 | Yes | Yes | |||
JSON_OVERLAPS() |
8.0.17 | Yes | ||||
JSON_PRETTY() |
5.7.22, 8.0.1 | Yes | Yes | |||
JSON_QUOTE() |
5.7.8 | Yes | Yes | |||
JSON_REMOVE() |
5.7.8 | Yes | Yes | |||
JSON_REPLACE() |
5.7.8 | Yes | Yes | |||
JSON_SCHEMA_VALID() |
8.0.17 | Yes | ||||
JSON_SCHEMA_VALIDATION_REPORT() |
8.0.17 | Yes | ||||
JSON_SEARCH() |
5.7.8 | Yes | Yes | |||
JSON_SET() |
5.7.8 | Yes | Yes | |||
JSON_STORAGE_FREE() |
8.0.2 | Yes | ||||
JSON_STORAGE_SIZE() |
5.7.22, 8.0.2 | Yes | Yes | |||
JSON_TABLE() |
8.0.4 | Yes | ||||
JSON_TYPE() |
5.7.8 | Yes | Yes | |||
JSON_UNQUOTE() |
5.7.8 | Yes | Yes | |||
JSON_VALID() |
5.7.8 | Yes | Yes | |||
JSON_VALUE() |
8.0.21 | Yes | ||||
LAG() |
8.0.2 | Yes | ||||
LAST_DAY |
Yes | Yes | Yes | |||
LAST_INSERT_ID() |
Yes | Yes | Yes | |||
LAST_VALUE() |
8.0.2 | Yes | ||||
LCASE() |
Yes | Yes | Yes | |||
LEAD() |
8.0.2 | Yes | ||||
LEAST() |
Yes | Yes | Yes | |||
LEFT() |
Yes | Yes | Yes | |||
LENGTH() |
Yes | Yes | Yes | |||
LIKE |
Yes | Yes | Yes | |||
LineFromText() , LineStringFromText()
|
5.7.6 | Yes | Yes | |||
LineFromWKB() , LineStringFromWKB()
|
5.7.6 | Yes | Yes | |||
LineString() |
Yes | Yes | Yes | |||
LN() |
Yes | Yes | Yes | |||
LOAD_FILE() |
Yes | Yes | Yes | |||
LOCALTIME() , LOCALTIME
|
Yes | Yes | Yes | |||
LOCALTIMESTAMP , LOCALTIMESTAMP()
|
Yes | Yes | Yes | |||
LOCATE() |
Yes | Yes | Yes | |||
LOG() |
Yes | Yes | Yes | |||
LOG10() |
Yes | Yes | Yes | |||
LOG2() |
Yes | Yes | Yes | |||
LOWER() |
Yes | Yes | Yes | |||
LPAD() |
Yes | Yes | Yes | |||
LTRIM() |
Yes | Yes | Yes | |||
MAKE_SET() |
Yes | Yes | Yes | |||
MAKEDATE() |
Yes | Yes | Yes | |||
MAKETIME() |
Yes | Yes | Yes | |||
MASTER_POS_WAIT() |
Yes | Yes | Yes | |||
MATCH |
Yes | Yes | Yes | |||
MAX() |
Yes | Yes | Yes | |||
MBRContains() |
Yes | Yes | Yes | |||
MBRCoveredBy() |
5.7.6 | Yes | Yes | |||
MBRCovers() |
5.7.6 | Yes | Yes | |||
MBRDisjoint() |
Yes | Yes | Yes | |||
MBREqual() |
5.7.6 | Yes | Yes | |||
MBREquals() |
5.7.6 | Yes | Yes | |||
MBRIntersects() |
Yes | Yes | Yes | |||
MBROverlaps() |
Yes | Yes | Yes | |||
MBRTouches() |
Yes | Yes | Yes | |||
MBRWithin() |
Yes | Yes | Yes | |||
MD5() |
Yes | Yes | Yes | |||
MEMBER OF() |
8.0.17 | Yes | ||||
MICROSECOND() |
Yes | Yes | Yes | |||
MID() |
Yes | Yes | Yes | |||
MIN() |
Yes | Yes | Yes | |||
MINUTE() |
Yes | Yes | Yes | |||
MLineFromText() , MultiLineStringFromText()
|
5.7.6 | Yes | Yes | |||
MLineFromWKB() , MultiLineStringFromWKB()
|
5.7.6 | Yes | Yes | |||
MOD() |
Yes | Yes | Yes | |||
MONTH() |
Yes | Yes | Yes | |||
MONTHNAME() |
Yes | Yes | Yes | |||
MPointFromText() , MultiPointFromText()
|
5.7.6 | Yes | Yes | |||
MPointFromWKB() , MultiPointFromWKB()
|
5.7.6 | Yes | Yes | |||
MPolyFromText() , MultiPolygonFromText()
|
5.7.6 | Yes | Yes | |||
MPolyFromWKB() , MultiPolygonFromWKB()
|
5.7.6 | Yes | Yes | |||
MultiLineString() |
Yes | Yes | Yes | |||
MultiPoint() |
Yes | Yes | Yes | |||
MultiPolygon() |
Yes | Yes | Yes | |||
NAME_CONST() |
Yes | Yes | Yes | |||
NOT , !
|
Yes | Yes | Yes | |||
NOT BETWEEN ... AND ... |
Yes | Yes | Yes | |||
NOT IN() |
Yes | Yes | Yes | |||
NOT LIKE |
Yes | Yes | Yes | |||
NOT REGEXP |
Yes | Yes | Yes | |||
NOW() |
Yes | Yes | Yes | |||
NTH_VALUE() |
8.0.2 | Yes | ||||
NTILE() |
8.0.2 | Yes | ||||
NULLIF() |
Yes | Yes | Yes | |||
NumGeometries() |
5.7.6 | Yes | Yes | |||
NumInteriorRings() |
5.7.6 | Yes | Yes | |||
NumPoints() |
5.7.6 | Yes | Yes | |||
OCT() |
Yes | Yes | Yes | |||
OCTET_LENGTH() |
Yes | Yes | Yes | |||
OLD_PASSWORD() |
5.6.5 | 5.7.5 | Yes | Yes | ||
OR , ||
|
Yes | Yes | Yes | |||
ORD() |
Yes | Yes | Yes | |||
Overlaps() |
5.7.6 | Yes | Yes | |||
PASSWORD() |
5.7.6 | 8.0.11 | Yes | Yes | Yes | |
PERCENT_RANK() |
8.0.2 | Yes | ||||
PERIOD_ADD() |
Yes | Yes | Yes | |||
PERIOD_DIFF() |
Yes | Yes | Yes | |||
PI() |
Yes | Yes | Yes | |||
Point() |
Yes | Yes | Yes | |||
PointFromText() |
5.7.6 | Yes | Yes | |||
PointFromWKB() |
5.7.6 | Yes | Yes | |||
PointN() |
5.7.6 | Yes | Yes | |||
PolyFromText() , PolygonFromText()
|
5.7.6 | Yes | Yes | |||
PolyFromWKB() , PolygonFromWKB()
|
5.7.6 | Yes | Yes | |||
Polygon() |
Yes | Yes | Yes | |||
POSITION() |
Yes | Yes | Yes | |||
POW() |
Yes | Yes | Yes | |||
POWER() |
Yes | Yes | Yes | |||
PROCEDURE ANALYSE() |
5.7.18 | Yes | Yes | |||
PS_CURRENT_THREAD_ID() |
8.0.16 | Yes | ||||
PS_THREAD_ID() |
8.0.16 | Yes | ||||
QUARTER() |
Yes | Yes | Yes | |||
QUOTE() |
Yes | Yes | Yes | |||
RADIANS() |
Yes | Yes | Yes | |||
RAND() |
Yes | Yes | Yes | |||
RANDOM_BYTES() |
5.6.17, 5.7.4 | Yes | Yes | Yes | ||
RANK() |
8.0.2 | Yes | ||||
REGEXP |
Yes | Yes | Yes | |||
REGEXP_INSTR() |
8.0.4 | Yes | ||||
REGEXP_LIKE() |
8.0.4 | Yes | ||||
REGEXP_REPLACE() |
8.0.4 | Yes | ||||
REGEXP_SUBSTR() |
8.0.4 | Yes | ||||
RELEASE_ALL_LOCKS() |
5.7.5 | Yes | Yes | |||
RELEASE_LOCK() |
Yes | Yes | Yes | |||
REPEAT() |
Yes | Yes | Yes | |||
REPLACE() |
Yes | Yes | Yes | |||
REVERSE() |
Yes | Yes | Yes | |||
RIGHT() |
Yes | Yes | Yes | |||
RLIKE |
Yes | Yes | Yes | |||
ROLES_GRAPHML() |
Yes | |||||
ROUND() |
Yes | Yes | Yes | |||
ROW_COUNT() |
Yes | Yes | Yes | |||
ROW_NUMBER() |
8.0.2 | Yes | ||||
RPAD() |
Yes | Yes | Yes | |||
RTRIM() |
Yes | Yes | Yes | |||
SCHEMA() |
Yes | Yes | Yes | |||
SEC_TO_TIME() |
Yes | Yes | Yes | |||
SECOND() |
Yes | Yes | Yes | |||
SESSION_USER() |
Yes | Yes | Yes | |||
SHA1() , SHA()
|
Yes | Yes | Yes | |||
SHA2() |
Yes | Yes | Yes | |||
SIGN() |
Yes | Yes | Yes | |||
SIN() |
Yes | Yes | Yes | |||
SLEEP() |
Yes | Yes | Yes | |||
SOUNDEX() |
Yes | Yes | Yes | |||
SOUNDS LIKE |
Yes | Yes | Yes | |||
SPACE() |
Yes | Yes | Yes | |||
SQL_THREAD_WAIT_AFTER_GTIDS() |
5.6.5 | 5.6.9 | Yes | |||
SQRT() |
Yes | Yes | Yes | |||
SRID() |
5.7.6 | Yes | Yes | |||
ST_Area() |
5.6.1 | Yes | Yes | Yes | ||
ST_AsBinary() , ST_AsWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_AsGeoJSON() |
5.7.5 | Yes | Yes | |||
ST_AsText() , ST_AsWKT()
|
5.6.1 | Yes | Yes | Yes | ||
ST_Buffer() |
5.6.1 | Yes | Yes | Yes | ||
ST_Buffer_Strategy() |
5.7.7 | Yes | Yes | |||
ST_Centroid() |
5.6.1 | Yes | Yes | Yes | ||
ST_Collect() |
8.0.24 | Yes | ||||
ST_Contains() |
5.6.1 | Yes | Yes | Yes | ||
ST_ConvexHull() |
5.7.5 | Yes | Yes | |||
ST_Crosses() |
5.6.1 | Yes | Yes | Yes | ||
ST_Difference() |
5.6.1 | Yes | Yes | Yes | ||
ST_Dimension() |
5.6.1 | Yes | Yes | Yes | ||
ST_Disjoint() |
5.6.1 | Yes | Yes | Yes | ||
ST_Distance() |
5.6.1 | Yes | Yes | Yes | ||
ST_Distance_Sphere() |
5.7.6 | Yes | Yes | |||
ST_EndPoint() |
5.6.1 | Yes | Yes | Yes | ||
ST_Envelope() |
5.6.1 | Yes | Yes | Yes | ||
ST_Equals() |
5.6.1 | Yes | Yes | Yes | ||
ST_ExteriorRing() |
5.6.1 | Yes | Yes | Yes | ||
ST_FrechetDistance() |
8.0.23 | Yes | ||||
ST_GeoHash() |
5.7.5 | Yes | Yes | |||
ST_GeomCollFromText() , ST_GeometryCollectionFromText() , ST_GeomCollFromTxt()
|
5.6.1 | Yes | Yes | Yes | ||
ST_GeomCollFromWKB() , ST_GeometryCollectionFromWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_GeometryN() |
5.6.1 | Yes | Yes | Yes | ||
ST_GeometryType() |
5.6.1 | Yes | Yes | Yes | ||
ST_GeomFromGeoJSON() |
5.7.5 | Yes | Yes | |||
ST_GeomFromText() , ST_GeometryFromText()
|
5.6.1 | Yes | Yes | Yes | ||
ST_GeomFromWKB() , ST_GeometryFromWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_HausdorffDistance() |
8.0.23 | Yes | ||||
ST_InteriorRingN() |
5.6.1 | Yes | Yes | Yes | ||
ST_Intersection() |
5.6.1 | Yes | Yes | Yes | ||
ST_Intersects() |
5.6.1 | Yes | Yes | Yes | ||
ST_IsClosed() |
5.6.1 | Yes | Yes | Yes | ||
ST_IsEmpty() |
5.6.1 | Yes | Yes | Yes | ||
ST_IsSimple() |
5.6.1 | Yes | Yes | Yes | ||
ST_IsValid() |
5.7.6 | Yes | Yes | |||
ST_LatFromGeoHash() |
5.7.5 | Yes | Yes | |||
ST_Latitude() |
8.0.12 | Yes | ||||
ST_Length() |
5.7.6 | Yes | Yes | |||
ST_LineFromText() , ST_LineStringFromText()
|
5.6.1 | Yes | Yes | Yes | ||
ST_LineFromWKB() , ST_LineStringFromWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_LineInterpolatePoint() |
8.0.24 | Yes | ||||
ST_LineInterpolatePoints() |
8.0.24 | Yes | ||||
ST_LongFromGeoHash() |
5.7.5 | Yes | Yes | |||
ST_Longitude() |
8.0.12 | Yes | ||||
ST_MakeEnvelope() |
5.7.6 | Yes | Yes | |||
ST_MLineFromText() , ST_MultiLineStringFromText()
|
5.7.6 | Yes | Yes | |||
ST_MLineFromWKB() , ST_MultiLineStringFromWKB()
|
5.7.6 | Yes | Yes | |||
ST_MPointFromText() , ST_MultiPointFromText()
|
5.7.6 | Yes | Yes | |||
ST_MPointFromWKB() , ST_MultiPointFromWKB()
|
5.7.6 | Yes | Yes | |||
ST_MPolyFromText() , ST_MultiPolygonFromText()
|
5.7.6 | Yes | Yes | |||
ST_MPolyFromWKB() , ST_MultiPolygonFromWKB()
|
5.7.6 | Yes | Yes | |||
ST_NumGeometries() |
5.6.1 | Yes | Yes | Yes | ||
ST_NumInteriorRing() , ST_NumInteriorRings()
|
5.6.1 | Yes | Yes | Yes | ||
ST_NumPoints() |
5.6.1 | Yes | Yes | Yes | ||
ST_Overlaps() |
5.6.1 | Yes | Yes | Yes | ||
ST_PointAtDistance() |
8.0.24 | Yes | ||||
ST_PointFromGeoHash() |
5.7.5 | Yes | Yes | |||
ST_PointFromText() |
5.6.1 | Yes | Yes | Yes | ||
ST_PointFromWKB() |
5.6.1 | Yes | Yes | Yes | ||
ST_PointN() |
5.6.1 | Yes | Yes | Yes | ||
ST_PolyFromText() , ST_PolygonFromText()
|
5.6.1 | Yes | Yes | Yes | ||
ST_PolyFromWKB() , ST_PolygonFromWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_Simplify() |
5.7.6 | Yes | Yes | |||
ST_SRID() |
5.6.1 | Yes | Yes | Yes | ||
ST_StartPoint() |
5.6.1 | Yes | Yes | Yes | ||
ST_SwapXY() |
8.0.1 | Yes | ||||
ST_SymDifference() |
5.6.1 | Yes | Yes | Yes | ||
ST_Touches() |
5.6.1 | Yes | Yes | Yes | ||
ST_Transform() |
8.0.13 | Yes | ||||
ST_Union() |
5.6.1 | Yes | Yes | Yes | ||
ST_Validate() |
5.7.6 | Yes | Yes | |||
ST_Within() |
5.6.1 | Yes | Yes | Yes | ||
ST_X() |
5.6.1 | Yes | Yes | Yes | ||
ST_Y() |
5.6.1 | Yes | Yes | Yes | ||
StartPoint() |
5.7.6 | Yes | Yes | |||
STATEMENT_DIGEST() |
8.0.4 | Yes | ||||
STATEMENT_DIGEST_TEXT() |
8.0.4 | Yes | ||||
STD() |
Yes | Yes | Yes | |||
STDDEV() |
Yes | Yes | Yes | |||
STDDEV_POP() |
Yes | Yes | Yes | |||
STDDEV_SAMP() |
Yes | Yes | Yes | |||
STR_TO_DATE() |
Yes | Yes | Yes | |||
STRCMP() |
Yes | Yes | Yes | |||
SUBDATE() |
Yes | Yes | Yes | |||
SUBSTR() |
Yes | Yes | Yes | |||
SUBSTRING() |
Yes | Yes | Yes | |||
SUBSTRING_INDEX() |
Yes | Yes | Yes | |||
SUBTIME() |
Yes | Yes | Yes | |||
SUM() |
Yes | Yes | Yes | |||
SYSDATE() |
Yes | Yes | Yes | |||
SYSTEM_USER() |
Yes | Yes | Yes | |||
TAN() |
Yes | Yes | Yes | |||
TIME() |
Yes | Yes | Yes | |||
TIME_FORMAT() |
Yes | Yes | Yes | |||
TIME_TO_SEC() |
Yes | Yes | Yes | |||
TIMEDIFF() |
Yes | Yes | Yes | |||
TIMESTAMP() |
Yes | Yes | Yes | |||
TIMESTAMPADD() |
Yes | Yes | Yes | |||
TIMESTAMPDIFF() |
Yes | Yes | Yes | |||
TO_BASE64() |
5.6.1 | Yes | Yes | Yes | ||
TO_DAYS() |
Yes | Yes | Yes | |||
TO_SECONDS() |
Yes | Yes | Yes | |||
Touches() |
5.7.6 | Yes | Yes | |||
TRIM() |
Yes | Yes | Yes | |||
TRUNCATE() |
Yes | Yes | Yes | |||
UCASE() |
Yes | Yes | Yes | |||
UNCOMPRESS() |
Yes | Yes | Yes | |||
UNCOMPRESSED_LENGTH() |
Yes | Yes | Yes | |||
UNHEX() |
Yes | Yes | Yes | |||
UNIX_TIMESTAMP() |
Yes | Yes | Yes | |||
UpdateXML() |
Yes | Yes | Yes | |||
UPPER() |
Yes | Yes | Yes | |||
USER() |
Yes | Yes | Yes | |||
UTC_DATE() |
Yes | Yes | Yes | |||
UTC_TIME() |
Yes | Yes | Yes | |||
UTC_TIMESTAMP() |
Yes | Yes | Yes | |||
UUID() |
Yes | Yes | Yes | |||
UUID_SHORT() |
Yes | Yes | Yes | |||
UUID_TO_BIN() |
Yes | |||||
VALIDATE_PASSWORD_STRENGTH() |
5.6.6 | Yes | Yes | Yes | ||
VALUES() |
Yes | Yes | Yes | |||
VAR_POP() |
Yes | Yes | Yes | |||
VAR_SAMP() |
Yes | Yes | Yes | |||
VARIANCE() |
Yes | Yes | Yes | |||
VERSION() |
Yes | Yes | Yes | |||
WAIT_FOR_EXECUTED_GTID_SET() |
5.7.5 | Yes | Yes | |||
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() |
5.6.9 | 8.0.18 | Yes | Yes | Yes | |
WEEK() |
Yes | Yes | Yes | |||
WEEKDAY() |
Yes | Yes | Yes | |||
WEEKOFYEAR() |
Yes | Yes | Yes | |||
WEIGHT_STRING() |
Yes | Yes | Yes | |||
Within() |
5.7.6 | Yes | Yes | |||
X() |
5.7.6 | Yes | Yes | |||
XOR |
Yes | Yes | Yes | |||
Y() |
5.7.6 | Yes | Yes | |||
YEAR() |
Yes | Yes | Yes | |||
YEARWEEK() |
Yes | Yes | Yes | |||
| |
Yes | Yes | Yes | |||
~ |
Yes | Yes | Yes |