MySQL Server Version Reference  /  Functions and Operators

Chapter 3 Functions and Operators

The following table provides a list of all the functions and operators supported across MySQL 5.5, 5.6, 5.7, and 8.0.

Table 3.1 Operators/Functions Reference

Name Introduced Deprecated 5.5 5.6 5.7 8.0
ABS()     Yes Yes Yes Yes
ACOS()     Yes Yes Yes Yes
ADDDATE()     Yes Yes Yes Yes
ADDTIME()     Yes Yes Yes Yes
AES_DECRYPT()     Yes Yes Yes Yes
AES_ENCRYPT()     Yes Yes Yes Yes
AND, &&     Yes Yes Yes Yes
ANY_VALUE() 5.7.5       Yes Yes
Area()   5.7.6 Yes Yes Yes  
AsBinary(), AsWKB()   5.7.6 Yes Yes Yes  
ASCII()     Yes Yes Yes Yes
ASIN()     Yes Yes Yes Yes
=     Yes Yes Yes Yes
:=     Yes Yes Yes Yes
AsText(), AsWKT()   5.7.6 Yes Yes Yes  
ASYMMETRIC_DECRYPT() 5.6.21, 5.7.9     Yes Yes Yes
ASYMMETRIC_DERIVE() 5.6.21, 5.7.9     Yes Yes Yes
ASYMMETRIC_ENCRYPT() 5.6.21, 5.7.9     Yes Yes Yes
ASYMMETRIC_SIGN() 5.6.21, 5.7.9     Yes Yes Yes
ASYMMETRIC_VERIFY() 5.6.21, 5.7.9     Yes Yes Yes
ATAN()     Yes Yes Yes Yes
ATAN2(), ATAN()     Yes Yes Yes Yes
AVG()     Yes Yes Yes Yes
BENCHMARK()     Yes Yes Yes Yes
BETWEEN ... AND ...     Yes Yes Yes Yes
BIN()     Yes Yes Yes Yes
BIN_TO_UUID()           Yes
BINARY     Yes Yes Yes Yes
BIT_AND()     Yes Yes Yes Yes
BIT_COUNT()     Yes Yes Yes Yes
BIT_LENGTH()     Yes Yes Yes Yes
BIT_OR()     Yes Yes Yes Yes
BIT_XOR()     Yes Yes Yes Yes
&     Yes Yes Yes Yes
~     Yes Yes Yes Yes
|     Yes Yes Yes Yes
^     Yes Yes Yes Yes
Buffer() 5.6.1 5.7.6   Yes Yes  
CASE     Yes Yes Yes Yes
CAST()     Yes Yes Yes Yes
CEIL()     Yes Yes Yes Yes
CEILING()     Yes Yes Yes Yes
Centroid()   5.7.6 Yes Yes Yes  
CHAR()     Yes Yes Yes Yes
CHAR_LENGTH()     Yes Yes Yes Yes
CHARACTER_LENGTH()     Yes Yes Yes Yes
CHARSET()     Yes Yes Yes Yes
COALESCE()     Yes Yes Yes Yes
COERCIBILITY()     Yes Yes Yes Yes
COLLATION()     Yes Yes Yes Yes
COMPRESS()     Yes Yes Yes Yes
CONCAT()     Yes Yes Yes Yes
CONCAT_WS()     Yes Yes Yes Yes
CONNECTION_ID()     Yes Yes Yes Yes
Contains()   5.7.6 Yes Yes Yes  
CONV()     Yes Yes Yes Yes
CONVERT()     Yes Yes Yes Yes
CONVERT_TZ()     Yes Yes Yes Yes
ConvexHull() 5.7.5 5.7.6     Yes  
COS()     Yes Yes Yes Yes
COT()     Yes Yes Yes Yes
COUNT()     Yes Yes Yes Yes
COUNT(DISTINCT)     Yes Yes Yes Yes
CRC32()     Yes Yes Yes Yes
CREATE_ASYMMETRIC_PRIV_KEY() 5.6.21, 5.7.9     Yes Yes Yes
CREATE_ASYMMETRIC_PUB_KEY() 5.6.21, 5.7.9     Yes Yes Yes
CREATE_DH_PARAMETERS() 5.6.21, 5.7.9     Yes Yes Yes
CREATE_DIGEST() 5.6.21, 5.7.9     Yes Yes Yes
Crosses()   5.7.6 Yes Yes Yes  
CURDATE()     Yes Yes Yes Yes
CURRENT_DATE(), CURRENT_DATE     Yes Yes Yes Yes
CURRENT_ROLE()           Yes
CURRENT_TIME(), CURRENT_TIME     Yes Yes Yes Yes
CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP     Yes Yes Yes Yes
CURRENT_USER(), CURRENT_USER     Yes Yes Yes Yes
CURTIME()     Yes Yes Yes Yes
DATABASE()     Yes Yes Yes Yes
DATE()     Yes Yes Yes Yes
DATE_ADD()     Yes Yes Yes Yes
DATE_FORMAT()     Yes Yes Yes Yes
DATE_SUB()     Yes Yes Yes Yes
DATEDIFF()     Yes Yes Yes Yes
DAY()     Yes Yes Yes Yes
DAYNAME()     Yes Yes Yes Yes
DAYOFMONTH()     Yes Yes Yes Yes
DAYOFWEEK()     Yes Yes Yes Yes
DAYOFYEAR()     Yes Yes Yes Yes
DECODE()     Yes Yes Yes Yes
DEFAULT()     Yes Yes Yes Yes
DEGREES()     Yes Yes Yes Yes
DES_DECRYPT()   5.7.6 Yes Yes Yes Yes
DES_ENCRYPT()   5.7.6 Yes Yes Yes Yes
Dimension()   5.7.6 Yes Yes Yes  
Disjoint()   5.7.6 Yes Yes Yes  
Distance() 5.7.5 5.7.6     Yes  
DIV     Yes Yes Yes Yes
/     Yes Yes Yes Yes
ELT()     Yes Yes Yes Yes
ENCODE()     Yes Yes Yes Yes
ENCRYPT()   5.7.6 Yes Yes Yes Yes
EndPoint()   5.7.6 Yes Yes Yes  
Envelope()   5.7.6 Yes Yes Yes  
=     Yes Yes Yes Yes
<=>     Yes Yes Yes Yes
Equals()   5.7.6 Yes Yes Yes  
EXP()     Yes Yes Yes Yes
EXPORT_SET()     Yes Yes Yes Yes
ExteriorRing()   5.7.6 Yes Yes Yes  
EXTRACT()     Yes Yes Yes Yes
ExtractValue()     Yes Yes Yes Yes
FIELD()     Yes Yes Yes Yes
FIND_IN_SET()     Yes Yes Yes Yes
FLOOR()     Yes Yes Yes Yes
FORMAT()     Yes Yes Yes Yes
FOUND_ROWS()     Yes Yes Yes Yes
FROM_BASE64() 5.6.1     Yes Yes Yes
FROM_DAYS()     Yes Yes Yes Yes
FROM_UNIXTIME()     Yes Yes Yes Yes
GeomCollFromText(), GeometryCollectionFromText()   5.7.6 Yes Yes Yes  
GeomCollFromWKB(), GeometryCollectionFromWKB()   5.7.6 Yes Yes Yes  
GeometryCollection()     Yes Yes Yes Yes
GeometryN()   5.7.6 Yes Yes Yes  
GeometryType()   5.7.6 Yes Yes Yes  
GeomFromText(), GeometryFromText()   5.7.6 Yes Yes Yes  
GeomFromWKB(), GeometryFromWKB()   5.7.6 Yes Yes Yes  
GET_FORMAT()     Yes Yes Yes Yes
GET_LOCK()     Yes Yes Yes Yes
GLength()   5.7.6 Yes Yes Yes  
>     Yes Yes Yes Yes
>=     Yes Yes Yes Yes
GREATEST()     Yes Yes Yes Yes
GROUP_CONCAT()     Yes Yes Yes Yes
GTID_SUBSET() 5.6.5     Yes Yes Yes
GTID_SUBTRACT() 5.6.5     Yes Yes Yes
HEX()     Yes Yes Yes Yes
HOUR()     Yes Yes Yes Yes
IF()     Yes Yes Yes Yes
IFNULL()     Yes Yes Yes Yes
IN()     Yes Yes Yes Yes
INET_ATON()     Yes Yes Yes Yes
INET_NTOA()     Yes Yes Yes Yes
INET6_ATON() 5.6.3     Yes Yes Yes
INET6_NTOA() 5.6.3     Yes Yes Yes
INSERT()     Yes Yes Yes Yes
INSTR()     Yes Yes Yes Yes
InteriorRingN()   5.7.6 Yes Yes Yes  
Intersects()   5.7.6 Yes Yes Yes  
INTERVAL()     Yes Yes Yes Yes
IS     Yes Yes Yes Yes
IS_FREE_LOCK()     Yes 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 Yes
IS NOT NULL     Yes Yes Yes Yes
IS NULL     Yes Yes Yes Yes
IS_USED_LOCK()     Yes Yes Yes Yes
IS_UUID()           Yes
IsClosed()   5.7.6 Yes Yes Yes  
IsEmpty()   5.7.6 Yes Yes Yes  
ISNULL()     Yes Yes Yes Yes
IsSimple()   5.7.6 Yes Yes Yes  
JSON_APPEND() 5.7.8       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() 8.0.1         Yes
-> 5.7.9       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
->> 5.7.13, 8.0.0       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       Yes Yes
JSON_OBJECT() 5.7.8       Yes Yes
JSON_OBJECTAGG() 8.0.1         Yes
JSON_QUOTE() 5.7.8       Yes Yes
JSON_REMOVE() 5.7.8       Yes Yes
JSON_REPLACE() 5.7.8       Yes Yes
JSON_SEARCH() 5.7.8       Yes Yes
JSON_SET() 5.7.8       Yes Yes
JSON_TYPE() 5.7.8       Yes Yes
JSON_UNQUOTE() 5.7.8       Yes Yes
JSON_VALID() 5.7.8       Yes Yes
LAST_DAY     Yes Yes Yes Yes
LAST_INSERT_ID()     Yes Yes Yes Yes
LCASE()     Yes Yes Yes Yes
LEAST()     Yes Yes Yes Yes
LEFT()     Yes Yes Yes Yes
<<     Yes Yes Yes Yes
LENGTH()     Yes Yes Yes Yes
<     Yes Yes Yes Yes
<=     Yes Yes Yes Yes
LIKE     Yes Yes Yes Yes
LineFromText(), LineStringFromText()   5.7.6 Yes Yes Yes  
LineFromWKB(), LineStringFromWKB()   5.7.6 Yes Yes Yes  
LineString()     Yes Yes Yes Yes
LN()     Yes Yes Yes Yes
LOAD_FILE()     Yes Yes Yes Yes
LOCALTIME(), LOCALTIME     Yes Yes Yes Yes
LOCALTIMESTAMP, LOCALTIMESTAMP()     Yes Yes Yes Yes
LOCATE()     Yes Yes Yes Yes
LOG()     Yes Yes Yes Yes
LOG10()     Yes Yes Yes Yes
LOG2()     Yes Yes Yes Yes
LOWER()     Yes Yes Yes Yes
LPAD()     Yes Yes Yes Yes
LTRIM()     Yes Yes Yes Yes
MAKE_SET()     Yes Yes Yes Yes
MAKEDATE()     Yes Yes Yes Yes
MAKETIME()     Yes Yes Yes Yes
MASTER_POS_WAIT()     Yes Yes Yes Yes
MATCH     Yes Yes Yes Yes
MAX()     Yes Yes Yes Yes
MBRContains()     Yes Yes Yes Yes
MBRCoveredBy() 5.7.6       Yes Yes
MBRCovers() 5.7.6       Yes Yes
MBRDisjoint()     Yes Yes Yes Yes
MBREqual()   5.7.6 Yes Yes Yes  
MBREquals() 5.7.6       Yes Yes
MBRIntersects()     Yes Yes Yes Yes
MBROverlaps()     Yes Yes Yes Yes
MBRTouches()     Yes Yes Yes Yes
MBRWithin()     Yes Yes Yes Yes
MD5()     Yes Yes Yes Yes
MICROSECOND()     Yes Yes Yes Yes
MID()     Yes Yes Yes Yes
MIN()     Yes Yes Yes Yes
-     Yes Yes Yes Yes
MINUTE()     Yes Yes Yes Yes
MLineFromText(), MultiLineStringFromText()   5.7.6 Yes Yes Yes  
MLineFromWKB(), MultiLineStringFromWKB()   5.7.6 Yes Yes Yes  
MOD()     Yes Yes Yes Yes
%, MOD     Yes Yes Yes Yes
MONTH()     Yes Yes Yes Yes
MONTHNAME()     Yes Yes Yes Yes
MPointFromText(), MultiPointFromText()   5.7.6 Yes Yes Yes  
MPointFromWKB(), MultiPointFromWKB()   5.7.6 Yes Yes Yes  
MPolyFromText(), MultiPolygonFromText()   5.7.6 Yes Yes Yes  
MPolyFromWKB(), MultiPolygonFromWKB()   5.7.6 Yes Yes Yes  
MultiLineString()     Yes Yes Yes Yes
MultiPoint()     Yes Yes Yes Yes
MultiPolygon()     Yes Yes Yes Yes
NAME_CONST()     Yes Yes Yes Yes
NOT, !     Yes Yes Yes Yes
NOT BETWEEN ... AND ...     Yes Yes Yes Yes
!=, <>     Yes Yes Yes Yes
NOT IN()     Yes Yes Yes Yes
NOT LIKE     Yes Yes Yes Yes
NOT REGEXP     Yes Yes Yes Yes
NOW()     Yes Yes Yes Yes
NULLIF()     Yes Yes Yes Yes
NumGeometries()   5.7.6 Yes Yes Yes  
NumInteriorRings()   5.7.6 Yes Yes Yes  
NumPoints()   5.7.6 Yes Yes Yes  
OCT()     Yes Yes Yes Yes
OCTET_LENGTH()     Yes Yes Yes Yes
OLD_PASSWORD()   5.6.5 Yes Yes Yes  
||, OR     Yes Yes Yes Yes
ORD()     Yes Yes Yes Yes
Overlaps()   5.7.6 Yes Yes Yes  
PASSWORD()   5.7.6 Yes Yes Yes Yes
PERIOD_ADD()     Yes Yes Yes Yes
PERIOD_DIFF()     Yes Yes Yes Yes
PI()     Yes Yes Yes Yes
+     Yes Yes Yes Yes
Point()     Yes Yes Yes Yes
PointFromText()   5.7.6 Yes Yes Yes  
PointFromWKB()   5.7.6 Yes Yes Yes  
PointN()   5.7.6 Yes Yes Yes  
PolyFromText(), PolygonFromText()   5.7.6 Yes Yes Yes  
PolyFromWKB(), PolygonFromWKB()   5.7.6 Yes Yes Yes  
Polygon()     Yes Yes Yes Yes
POSITION()     Yes Yes Yes Yes
POW()     Yes Yes Yes Yes
POWER()     Yes Yes Yes Yes
PROCEDURE ANALYSE()     Yes Yes Yes Yes
QUARTER()     Yes Yes Yes Yes
QUOTE()     Yes Yes Yes Yes
RADIANS()     Yes Yes Yes Yes
RAND()     Yes Yes Yes Yes
RANDOM_BYTES() 5.6.17, 5.7.4     Yes Yes Yes
REGEXP     Yes Yes Yes Yes
RELEASE_ALL_LOCKS() 5.7.5       Yes Yes
RELEASE_LOCK()     Yes Yes Yes Yes
REPEAT()     Yes Yes Yes Yes
REPLACE()     Yes Yes Yes Yes
REVERSE()     Yes Yes Yes Yes
RIGHT()     Yes Yes Yes Yes
>>     Yes Yes Yes Yes
RLIKE     Yes Yes Yes Yes
ROLES_GRAPHML()           Yes
ROUND()     Yes Yes Yes Yes
ROW_COUNT()     Yes Yes Yes Yes
RPAD()     Yes Yes Yes Yes
RTRIM()     Yes Yes Yes Yes
SCHEMA()     Yes Yes Yes Yes
SEC_TO_TIME()     Yes Yes Yes Yes
SECOND()     Yes Yes Yes Yes
SESSION_USER()     Yes Yes Yes Yes
SHA1(), SHA()     Yes Yes Yes Yes
SHA2() 5.5.5   Yes Yes Yes Yes
SIGN()     Yes Yes Yes Yes
SIN()     Yes Yes Yes Yes
SLEEP()     Yes Yes Yes Yes
SOUNDEX()     Yes Yes Yes Yes
SOUNDS LIKE     Yes Yes Yes Yes
SPACE()     Yes Yes Yes Yes
SQL_THREAD_WAIT_AFTER_GTIDS() 5.6.5 5.6.9   Yes    
SQRT()     Yes Yes Yes Yes
SRID()   5.7.6 Yes 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_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_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_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_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_LongFromGeoHash() 5.7.5       Yes 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_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_SymDifference() 5.6.1     Yes Yes Yes
ST_Touches() 5.6.1     Yes Yes 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 Yes  
STD()     Yes Yes Yes Yes
STDDEV()     Yes Yes Yes Yes
STDDEV_POP()     Yes Yes Yes Yes
STDDEV_SAMP()     Yes Yes Yes Yes
STR_TO_DATE()     Yes Yes Yes Yes
STRCMP()     Yes Yes Yes Yes
SUBDATE()     Yes Yes Yes Yes
SUBSTR()     Yes Yes Yes Yes
SUBSTRING()     Yes Yes Yes Yes
SUBSTRING_INDEX()     Yes Yes Yes Yes
SUBTIME()     Yes Yes Yes Yes
SUM()     Yes Yes Yes Yes
SYSDATE()     Yes Yes Yes Yes
SYSTEM_USER()     Yes Yes Yes Yes
TAN()     Yes Yes Yes Yes
TIME()     Yes Yes Yes Yes
TIME_FORMAT()     Yes Yes Yes Yes
TIME_TO_SEC()     Yes Yes Yes Yes
TIMEDIFF()     Yes Yes Yes Yes
*     Yes Yes Yes Yes
TIMESTAMP()     Yes Yes Yes Yes
TIMESTAMPADD()     Yes Yes Yes Yes
TIMESTAMPDIFF()     Yes Yes Yes Yes
TO_BASE64() 5.6.1     Yes Yes Yes
TO_DAYS()     Yes Yes Yes Yes
TO_SECONDS()     Yes Yes Yes Yes
Touches()   5.7.6 Yes Yes Yes  
TRIM()     Yes Yes Yes Yes
TRUNCATE()     Yes Yes Yes Yes
UCASE()     Yes Yes Yes Yes
-     Yes Yes Yes Yes
UNCOMPRESS()     Yes Yes Yes Yes
UNCOMPRESSED_LENGTH()     Yes Yes Yes Yes
UNHEX()     Yes Yes Yes Yes
UNIX_TIMESTAMP()     Yes Yes Yes Yes
UpdateXML()     Yes Yes Yes Yes
UPPER()     Yes Yes Yes Yes
USER()     Yes Yes Yes Yes
UTC_DATE()     Yes Yes Yes Yes
UTC_TIME()     Yes Yes Yes Yes
UTC_TIMESTAMP()     Yes Yes Yes Yes
UUID()     Yes Yes Yes Yes
UUID_SHORT()     Yes Yes Yes Yes
UUID_TO_BIN()           Yes
VALIDATE_PASSWORD_STRENGTH() 5.6.6     Yes Yes Yes
VALUES()     Yes Yes Yes Yes
VAR_POP()     Yes Yes Yes Yes
VAR_SAMP()     Yes Yes Yes Yes
VARIANCE()     Yes Yes Yes Yes
VERSION()     Yes Yes Yes Yes
WAIT_FOR_EXECUTED_GTID_SET() 5.7.5       Yes Yes
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() 5.6.9     Yes Yes Yes
WEEK()     Yes Yes Yes Yes
WEEKDAY()     Yes Yes Yes Yes
WEEKOFYEAR()     Yes Yes Yes Yes
WEIGHT_STRING()       Yes Yes Yes
Within()   5.7.6 Yes Yes Yes  
X()   5.7.6 Yes Yes Yes  
XOR     Yes Yes Yes Yes
Y()   5.7.6 Yes Yes Yes  
YEAR()     Yes Yes Yes Yes
YEARWEEK()     Yes Yes Yes Yes