MySQL Server Version Reference / SQL Functions and Operators

Chapter 2 SQL Functions and Operators

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

PREV HOME UP NEXT