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.0, 5.1, 5.5, 5.6, and 5.7.

Table 3.1 Operators/Functions Reference

Name Introduced Deprecated 5.0 5.1 5.5 5.6 5.7
ABS() Yes Yes Yes Yes Yes
ACOS() Yes Yes Yes Yes Yes
ADDDATE() Yes Yes Yes Yes Yes
ADDTIME() Yes Yes Yes Yes Yes
AES_DECRYPT() Yes Yes Yes Yes Yes
AES_ENCRYPT() Yes Yes Yes Yes Yes
AND, && Yes Yes Yes Yes Yes
ANY_VALUE() 5.7.5 Yes
Area() 5.7.6 Yes Yes Yes Yes Yes
AsBinary(), AsWKB() 5.7.6 Yes Yes Yes Yes Yes
ASCII() Yes Yes Yes Yes Yes
ASIN() Yes Yes Yes Yes Yes
= Yes Yes Yes Yes Yes
:= Yes Yes Yes Yes Yes
AsText(), AsWKT() 5.7.6 Yes Yes Yes Yes Yes
ASYMMETRIC_DECRYPT() 5.6.21, 5.7.9 Yes Yes
ASYMMETRIC_DERIVE() 5.6.21, 5.7.9 Yes Yes
ASYMMETRIC_ENCRYPT() 5.6.21, 5.7.9 Yes Yes
ASYMMETRIC_SIGN() 5.6.21, 5.7.9 Yes Yes
ASYMMETRIC_VERIFY() 5.6.21, 5.7.9 Yes Yes
ATAN() Yes Yes Yes Yes Yes
ATAN2(), ATAN() Yes Yes Yes Yes Yes
AVG() Yes Yes Yes Yes Yes
BENCHMARK() Yes Yes Yes Yes Yes
BETWEEN ... AND ... Yes Yes Yes Yes Yes
BIN() Yes Yes Yes Yes Yes
BINARY Yes Yes Yes Yes Yes
BIT_AND() Yes Yes Yes Yes Yes
BIT_COUNT() Yes Yes Yes Yes Yes
BIT_LENGTH() Yes Yes Yes Yes Yes
BIT_OR() Yes 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
^ Yes Yes Yes Yes Yes
Buffer() 5.6.1 5.7.6 Yes Yes
CASE Yes Yes Yes Yes Yes
CAST() Yes Yes Yes Yes Yes
CEIL() Yes Yes Yes Yes Yes
CEILING() Yes Yes Yes Yes Yes
Centroid() 5.7.6 Yes Yes Yes Yes Yes
CHAR() Yes Yes Yes Yes Yes
CHAR_LENGTH() Yes Yes Yes Yes Yes
CHARACTER_LENGTH() Yes Yes Yes Yes Yes
CHARSET() Yes Yes Yes Yes Yes
COALESCE() Yes Yes Yes Yes Yes
COERCIBILITY() Yes Yes Yes Yes Yes
COLLATION() Yes Yes Yes Yes Yes
COMPRESS() Yes Yes Yes Yes Yes
CONCAT() Yes Yes Yes Yes Yes
CONCAT_WS() Yes Yes Yes Yes Yes
CONNECTION_ID() Yes Yes Yes Yes Yes
Contains() 5.7.6 Yes Yes Yes Yes Yes
CONV() Yes Yes Yes Yes Yes
CONVERT() Yes Yes Yes Yes Yes
CONVERT_TZ() Yes Yes Yes Yes Yes
ConvexHull() 5.7.5 5.7.6 Yes
COS() Yes Yes Yes Yes Yes
COT() Yes Yes Yes Yes Yes
COUNT() Yes Yes Yes Yes Yes
COUNT(DISTINCT) Yes Yes Yes Yes Yes
CRC32() Yes Yes Yes Yes Yes
CREATE_ASYMMETRIC_PRIV_KEY() 5.6.21, 5.7.9 Yes Yes
CREATE_ASYMMETRIC_PUB_KEY() 5.6.21, 5.7.9 Yes Yes
CREATE_DH_PARAMETERS() 5.6.21, 5.7.9 Yes Yes
CREATE_DIGEST() 5.6.21, 5.7.9 Yes Yes
Crosses() 5.7.6 Yes Yes Yes Yes Yes
CURDATE() Yes Yes Yes Yes Yes
CURRENT_DATE(), CURRENT_DATE Yes Yes Yes Yes Yes
CURRENT_TIME(), CURRENT_TIME Yes Yes Yes Yes Yes
CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP Yes Yes Yes Yes Yes
CURRENT_USER(), CURRENT_USER Yes Yes Yes Yes Yes
CURTIME() Yes Yes Yes Yes Yes
DATABASE() Yes Yes Yes Yes Yes
DATE() Yes Yes Yes Yes Yes
DATE_ADD() Yes Yes Yes Yes Yes
DATE_FORMAT() Yes Yes Yes Yes Yes
DATE_SUB() Yes Yes Yes Yes Yes
DATEDIFF() Yes Yes Yes Yes Yes
DAY() Yes Yes Yes Yes Yes
DAYNAME() Yes Yes Yes Yes Yes
DAYOFMONTH() Yes Yes Yes Yes Yes
DAYOFWEEK() Yes Yes Yes Yes Yes
DAYOFYEAR() Yes Yes Yes Yes Yes
DECODE() Yes Yes Yes Yes Yes
DEFAULT() Yes Yes Yes Yes Yes
DEGREES() Yes Yes Yes Yes Yes
DES_DECRYPT() 5.7.6 Yes Yes Yes Yes Yes
DES_ENCRYPT() 5.7.6 Yes Yes Yes Yes Yes
Dimension() 5.7.6 Yes Yes Yes Yes Yes
Disjoint() 5.7.6 Yes Yes Yes Yes Yes
Distance() 5.7.5 5.7.6 Yes
DIV Yes Yes Yes Yes Yes
/ Yes Yes Yes Yes Yes
ELT() Yes Yes Yes Yes Yes
ENCODE() Yes Yes Yes Yes Yes
ENCRYPT() 5.7.6 Yes Yes Yes Yes Yes
EndPoint() 5.7.6 Yes Yes Yes Yes Yes
Envelope() 5.7.6 Yes Yes Yes Yes Yes
= Yes Yes Yes Yes Yes
<=> Yes Yes Yes Yes Yes
Equals() 5.7.6 Yes Yes Yes Yes Yes
EXP() Yes Yes Yes Yes Yes
EXPORT_SET() Yes Yes Yes Yes Yes
ExteriorRing() 5.7.6 Yes Yes Yes Yes Yes
EXTRACT() Yes Yes Yes Yes Yes
ExtractValue() 5.1.5 Yes Yes Yes Yes
FIELD() Yes Yes Yes Yes Yes
FIND_IN_SET() Yes Yes Yes Yes Yes
FLOOR() Yes Yes Yes Yes Yes
FORMAT() Yes Yes Yes Yes Yes
FOUND_ROWS() Yes Yes Yes Yes Yes
FROM_BASE64() 5.6.1 Yes Yes
FROM_DAYS() Yes Yes Yes Yes Yes
FROM_UNIXTIME() Yes Yes Yes Yes Yes
GeomCollFromText(), GeometryCollectionFromText() 5.7.6 Yes Yes Yes Yes Yes
GeomCollFromWKB(), GeometryCollectionFromWKB() 5.7.6 Yes Yes Yes Yes Yes
GeometryCollection() Yes Yes Yes Yes Yes
GeometryN() 5.7.6 Yes Yes Yes Yes Yes
GeometryType() 5.7.6 Yes Yes Yes Yes Yes
GeomFromText(), GeometryFromText() 5.7.6 Yes Yes Yes Yes Yes
GeomFromWKB(), GeometryFromWKB() 5.7.6 Yes Yes Yes Yes Yes
GET_FORMAT() Yes Yes Yes Yes Yes
GET_LOCK() Yes Yes Yes Yes Yes
GLength() 5.7.6 Yes Yes Yes Yes Yes
> Yes Yes Yes Yes Yes
>= Yes Yes Yes Yes Yes
GREATEST() Yes Yes Yes Yes Yes
GROUP_CONCAT() Yes Yes Yes Yes Yes
GTID_SUBSET() 5.6.5 Yes Yes
GTID_SUBTRACT() 5.6.5 Yes Yes
HEX() Yes Yes Yes Yes Yes
HOUR() Yes Yes Yes Yes Yes
IF() Yes Yes Yes Yes Yes
IFNULL() Yes Yes Yes Yes Yes
IN() Yes Yes Yes Yes Yes
INET_ATON() Yes Yes Yes Yes Yes
INET_NTOA() Yes Yes Yes Yes Yes
INET6_ATON() 5.6.3 Yes Yes
INET6_NTOA() 5.6.3 Yes Yes
INSERT() Yes Yes Yes Yes Yes
INSTR() Yes Yes Yes Yes Yes
InteriorRingN() 5.7.6 Yes Yes Yes Yes Yes
Intersects() 5.7.6 Yes Yes Yes Yes Yes
INTERVAL() Yes Yes Yes Yes Yes
IS Yes Yes Yes Yes Yes
IS_FREE_LOCK() Yes Yes Yes Yes Yes
IS_IPV4() 5.6.3 Yes Yes
IS_IPV4_COMPAT() 5.6.3 Yes Yes
IS_IPV4_MAPPED() 5.6.3 Yes Yes
IS_IPV6() 5.6.3 Yes Yes
IS NOT Yes Yes Yes Yes Yes
IS NOT NULL Yes Yes Yes Yes Yes
IS NULL Yes Yes Yes Yes Yes
IS_USED_LOCK() Yes Yes Yes Yes Yes
IsClosed() 5.7.6 Yes Yes Yes Yes Yes
IsEmpty() 5.7.6 Yes Yes Yes Yes Yes
ISNULL() Yes Yes Yes Yes Yes
IsSimple() 5.7.6 Yes Yes Yes Yes Yes
JSON_APPEND() 5.7.8 Yes
JSON_ARRAY() 5.7.8 Yes
JSON_ARRAY_APPEND() 5.7.9 Yes
JSON_ARRAY_INSERT() 5.7.8 Yes
-> Yes
JSON_CONTAINS() 5.7.8 Yes
JSON_CONTAINS_PATH() 5.7.8 Yes
JSON_DEPTH() 5.7.8 Yes
JSON_EXTRACT() 5.7.8 Yes
JSON_INSERT() 5.7.8 Yes
JSON_KEYS() 5.7.8 Yes
JSON_LENGTH() 5.7.8 Yes
JSON_MERGE() 5.7.8 Yes
JSON_OBJECT() 5.7.8 Yes
JSON_QUOTE() 5.7.8 Yes
JSON_REMOVE() 5.7.8 Yes
JSON_REPLACE() 5.7.8 Yes
JSON_SEARCH() 5.7.8 Yes
JSON_SET() 5.7.8 Yes
JSON_TYPE() 5.7.8 Yes
JSON_UNQUOTE() 5.7.8 Yes
JSON_VALID() 5.7.8 Yes
LAST_DAY Yes Yes Yes Yes Yes
LAST_INSERT_ID() Yes Yes Yes Yes Yes
LCASE() Yes Yes Yes Yes Yes
LEAST() Yes Yes Yes Yes Yes
LEFT() Yes Yes Yes Yes Yes
<< Yes Yes Yes Yes Yes
LENGTH() Yes Yes Yes Yes Yes
< Yes Yes Yes Yes Yes
<= Yes Yes Yes Yes Yes
LIKE Yes Yes Yes Yes Yes
LineFromText(), LineStringFromText() 5.7.6 Yes Yes Yes Yes Yes
LineFromWKB(), LineStringFromWKB() 5.7.6 Yes Yes Yes Yes Yes
LineString() Yes Yes Yes Yes Yes
LN() Yes Yes Yes Yes Yes
LOAD_FILE() Yes Yes Yes Yes Yes
LOCALTIME(), LOCALTIME Yes Yes Yes Yes Yes
LOCALTIMESTAMP, LOCALTIMESTAMP() Yes Yes Yes Yes Yes
LOCATE() Yes Yes Yes Yes Yes
LOG() Yes Yes Yes Yes Yes
LOG10() Yes Yes Yes Yes Yes
LOG2() Yes Yes Yes Yes Yes
LOWER() Yes Yes Yes Yes Yes
LPAD() Yes Yes Yes Yes Yes
LTRIM() Yes Yes Yes Yes Yes
MAKE_SET() Yes Yes Yes Yes Yes
MAKEDATE() Yes Yes Yes Yes Yes
MAKETIME() Yes Yes Yes Yes Yes
MASTER_POS_WAIT() Yes Yes Yes Yes Yes
MATCH Yes Yes Yes Yes Yes
MAX() Yes Yes Yes Yes Yes
MBRContains() Yes Yes Yes Yes Yes
MBRCoveredBy() 5.7.6 Yes
MBRCovers() 5.7.6 Yes
MBRDisjoint() Yes Yes Yes Yes Yes
MBREqual() 5.7.6 Yes Yes Yes Yes Yes
MBREquals() 5.7.6 Yes
MBRIntersects() Yes Yes Yes Yes Yes
MBROverlaps() Yes Yes Yes Yes Yes
MBRTouches() Yes Yes Yes Yes Yes
MBRWithin() Yes Yes Yes Yes Yes
MD5() Yes Yes Yes Yes Yes
MICROSECOND() Yes Yes Yes Yes Yes
MID() Yes Yes Yes Yes Yes
MIN() Yes Yes Yes Yes Yes
- Yes Yes Yes Yes Yes
MINUTE() Yes Yes Yes Yes Yes
MLineFromText(), MultiLineStringFromText() 5.7.6 Yes Yes Yes Yes Yes
MLineFromWKB(), MultiLineStringFromWKB() 5.7.6 Yes Yes Yes Yes Yes
MOD() Yes Yes Yes Yes Yes
%, MOD Yes Yes Yes Yes Yes
MONTH() Yes Yes Yes Yes Yes
MONTHNAME() Yes Yes Yes Yes Yes
MPointFromText(), MultiPointFromText() 5.7.6 Yes Yes Yes Yes Yes
MPointFromWKB(), MultiPointFromWKB() 5.7.6 Yes Yes Yes Yes Yes
MPolyFromText(), MultiPolygonFromText() 5.7.6 Yes Yes Yes Yes Yes
MPolyFromWKB(), MultiPolygonFromWKB() 5.7.6 Yes Yes Yes Yes Yes
MultiLineString() Yes Yes Yes Yes Yes
MultiPoint() Yes Yes Yes Yes Yes
MultiPolygon() Yes Yes Yes Yes Yes
NAME_CONST() 5.0.12 Yes Yes Yes Yes Yes
NOT, ! Yes Yes Yes Yes Yes
NOT BETWEEN ... AND ... Yes Yes Yes Yes Yes
!=, <> Yes Yes Yes Yes Yes
NOT IN() Yes Yes Yes Yes Yes
NOT LIKE Yes Yes Yes Yes Yes
NOT REGEXP Yes Yes Yes Yes Yes
NOW() Yes Yes Yes Yes Yes
NULLIF() Yes Yes Yes Yes Yes
NumGeometries() 5.7.6 Yes Yes Yes Yes Yes
NumInteriorRings() 5.7.6 Yes Yes Yes Yes Yes
NumPoints() 5.7.6 Yes Yes Yes Yes Yes
OCT() Yes Yes Yes Yes Yes
OCTET_LENGTH() Yes Yes Yes Yes Yes
OLD_PASSWORD() 5.6.5 Yes Yes Yes Yes Yes
||, OR Yes Yes Yes Yes Yes
ORD() Yes Yes Yes Yes Yes
Overlaps() 5.7.6 Yes Yes Yes Yes Yes
PASSWORD() 5.7.6 Yes Yes Yes Yes Yes
PERIOD_ADD() Yes Yes Yes Yes Yes
PERIOD_DIFF() Yes Yes Yes Yes Yes
PI() Yes Yes Yes Yes Yes
+ Yes Yes Yes Yes Yes
Point() Yes Yes Yes Yes Yes
PointFromText() 5.7.6 Yes Yes Yes Yes Yes
PointFromWKB() 5.7.6 Yes Yes Yes Yes Yes
PointN() 5.7.6 Yes Yes Yes Yes Yes
PolyFromText(), PolygonFromText() 5.7.6 Yes Yes Yes Yes Yes
PolyFromWKB(), PolygonFromWKB() 5.7.6 Yes Yes Yes Yes Yes
Polygon() Yes Yes Yes Yes Yes
POSITION() Yes Yes Yes Yes Yes
POW() Yes Yes Yes Yes Yes
POWER() Yes Yes Yes Yes Yes
PROCEDURE ANALYSE() Yes Yes Yes Yes Yes
QUARTER() Yes Yes Yes Yes Yes
QUOTE() Yes Yes Yes Yes Yes
RADIANS() Yes Yes Yes Yes Yes
RAND() Yes Yes Yes Yes Yes
RANDOM_BYTES() 5.6.17, 5.7.4 Yes Yes
REGEXP Yes Yes Yes Yes Yes
RELEASE_ALL_LOCKS() 5.7.5 Yes
RELEASE_LOCK() Yes Yes Yes Yes Yes
REPEAT() Yes Yes Yes Yes Yes
REPLACE() Yes Yes Yes Yes Yes
REVERSE() Yes Yes Yes Yes Yes
RIGHT() Yes Yes Yes Yes Yes
>> Yes Yes Yes Yes Yes
RLIKE Yes Yes Yes Yes Yes
ROUND() Yes Yes Yes Yes Yes
ROW_COUNT() 5.0.1 Yes Yes Yes Yes Yes
RPAD() Yes Yes Yes Yes Yes
RTRIM() Yes Yes Yes Yes Yes
SCHEMA() 5.0.2 Yes Yes Yes Yes Yes
SEC_TO_TIME() Yes Yes Yes Yes Yes
SECOND() Yes Yes Yes Yes Yes
SESSION_USER() Yes Yes Yes Yes Yes
SHA1(), SHA() Yes Yes Yes Yes Yes
SHA2() 5.5.5 Yes Yes Yes
SIGN() Yes Yes Yes Yes Yes
SIN() Yes Yes Yes Yes Yes
SLEEP() 5.0.12 Yes Yes Yes Yes Yes
SOUNDEX() Yes Yes Yes Yes Yes
SOUNDS LIKE Yes Yes Yes Yes Yes
SPACE() Yes Yes Yes Yes Yes
SQL_THREAD_WAIT_AFTER_GTIDS() 5.6.5 5.6.9 Yes
SQRT() Yes Yes Yes Yes Yes
SRID() 5.7.6 Yes Yes Yes Yes Yes
ST_Area() 5.6.1 Yes Yes
ST_AsBinary(), ST_AsWKB() 5.6.1 Yes Yes
ST_AsGeoJSON() 5.7.5 Yes
ST_AsText(), ST_AsWKT() 5.6.1 Yes Yes
ST_Buffer() 5.6.1 Yes Yes
ST_Buffer_Strategy() 5.7.7 Yes
ST_Centroid() 5.6.1 Yes Yes
ST_Contains() 5.6.1 Yes Yes
ST_ConvexHull() 5.7.5 Yes
ST_Crosses() 5.6.1 Yes Yes
ST_Difference() 5.6.1 Yes Yes
ST_Dimension() 5.6.1 Yes Yes
ST_Disjoint() 5.6.1 Yes Yes
ST_Distance() 5.6.1 Yes Yes
ST_Distance_Sphere() 5.7.6 Yes
ST_EndPoint() 5.6.1 Yes Yes
ST_Envelope() 5.6.1 Yes Yes
ST_Equals() 5.6.1 Yes Yes
ST_ExteriorRing() 5.6.1 Yes Yes
ST_GeoHash() 5.7.5 Yes
ST_GeomCollFromText(), ST_GeometryCollectionFromText(), ST_GeomCollFromTxt() 5.6.1 Yes Yes
ST_GeomCollFromWKB(), ST_GeometryCollectionFromWKB() 5.6.1 Yes Yes
ST_GeometryN() 5.6.1 Yes Yes
ST_GeometryType() 5.6.1 Yes Yes
ST_GeomFromGeoJSON() 5.7.5 Yes
ST_GeomFromText(), ST_GeometryFromText() 5.6.1 Yes Yes
ST_GeomFromWKB(), ST_GeometryFromWKB() 5.6.1 Yes Yes
ST_InteriorRingN() 5.6.1 Yes Yes
ST_Intersection() 5.6.1 Yes Yes
ST_Intersects() 5.6.1 Yes Yes
ST_IsClosed() 5.6.1 Yes Yes
ST_IsEmpty() 5.6.1 Yes Yes
ST_IsSimple() 5.6.1 Yes Yes
ST_IsValid() 5.7.6 Yes
ST_LatFromGeoHash() 5.7.5 Yes
ST_Length() 5.7.6 Yes
ST_LineFromText() 5.6.1 Yes Yes
ST_LineFromWKB(), ST_LineStringFromWKB() 5.6.1 Yes Yes
ST_LongFromGeoHash() 5.7.5 Yes
ST_MakeEnvelope() 5.7.6 Yes
ST_MLineFromText(), ST_MultiLineStringFromText() 5.7.6 Yes
ST_MLineFromWKB(), ST_MultiLineStringFromWKB() 5.7.6 Yes
ST_MPointFromText(), ST_MultiPointFromText() 5.7.6 Yes
ST_MPointFromWKB(), ST_MultiPointFromWKB() 5.7.6 Yes
ST_MPolyFromText(), ST_MultiPolygonFromText() 5.7.6 Yes
ST_MPolyFromWKB(), ST_MultiPolygonFromWKB() 5.7.6 Yes
ST_NumGeometries() 5.6.1 Yes Yes
ST_NumInteriorRing(), ST_NumInteriorRings() 5.6.1 Yes Yes
ST_NumPoints() 5.6.1 Yes Yes
ST_Overlaps() 5.6.1 Yes Yes
ST_PointFromGeoHash() 5.7.5 Yes
ST_PointFromText() 5.6.1 Yes Yes
ST_PointFromWKB() 5.6.1 Yes Yes
ST_PointN() 5.6.1 Yes Yes
ST_PolyFromText(), ST_PolygonFromText() 5.6.1 Yes Yes
ST_PolyFromWKB(), ST_PolygonFromWKB() 5.6.1 Yes Yes
ST_Simplify() 5.7.6 Yes
ST_SRID() 5.6.1 Yes Yes
ST_StartPoint() 5.6.1 Yes Yes
ST_SymDifference() 5.6.1 Yes Yes
ST_Touches() 5.6.1 Yes Yes
ST_Union() 5.6.1 Yes Yes
ST_Validate() 5.7.6 Yes
ST_Within() 5.6.1 Yes Yes
ST_X() 5.6.1 Yes Yes
ST_Y() 5.6.1 Yes Yes
StartPoint() 5.7.6 Yes Yes Yes Yes Yes
STD() Yes Yes Yes Yes Yes
STDDEV() Yes Yes Yes Yes Yes
STDDEV_POP() 5.0.3 Yes Yes Yes Yes Yes
STDDEV_SAMP() 5.0.3 Yes Yes Yes Yes Yes
STR_TO_DATE() Yes Yes Yes Yes Yes
STRCMP() Yes Yes Yes Yes Yes
SUBDATE() Yes Yes Yes Yes Yes
SUBSTR() Yes Yes Yes Yes Yes
SUBSTRING() Yes Yes Yes Yes Yes
SUBSTRING_INDEX() Yes Yes Yes Yes Yes
SUBTIME() Yes Yes Yes Yes Yes
SUM() Yes Yes Yes Yes Yes
SYSDATE() Yes Yes Yes Yes Yes
SYSTEM_USER() Yes Yes Yes Yes Yes
TAN() Yes Yes Yes Yes Yes
TIME() Yes Yes Yes Yes Yes
TIME_FORMAT() Yes Yes Yes Yes Yes
TIME_TO_SEC() Yes Yes Yes Yes Yes
TIMEDIFF() Yes Yes Yes Yes Yes
* Yes Yes Yes Yes Yes
TIMESTAMP() Yes Yes Yes Yes Yes
TIMESTAMPADD() Yes Yes Yes Yes Yes
TIMESTAMPDIFF() Yes Yes Yes Yes Yes
TO_BASE64() 5.6.1 Yes Yes
TO_DAYS() Yes Yes Yes Yes Yes
TO_SECONDS() Yes Yes Yes
Touches() 5.7.6 Yes Yes Yes Yes Yes
TRIM() Yes Yes Yes Yes Yes
TRUNCATE() Yes Yes Yes Yes Yes
UCASE() Yes Yes Yes Yes Yes
- Yes Yes Yes Yes Yes
UNCOMPRESS() Yes Yes Yes Yes Yes
UNCOMPRESSED_LENGTH() Yes Yes Yes Yes Yes
UNHEX() Yes Yes Yes Yes Yes
UNIX_TIMESTAMP() Yes Yes Yes Yes Yes
UpdateXML() 5.1.5 Yes Yes Yes Yes
UPPER() Yes Yes Yes Yes Yes
USER() Yes Yes Yes Yes Yes
UTC_DATE() Yes Yes Yes Yes Yes
UTC_TIME() Yes Yes Yes Yes Yes
UTC_TIMESTAMP() Yes Yes Yes Yes Yes
UUID() Yes Yes Yes Yes Yes
UUID_SHORT() 5.1.20 Yes Yes Yes Yes
VALIDATE_PASSWORD_STRENGTH() 5.6.6 Yes Yes
VALUES() Yes Yes Yes Yes Yes
VAR_POP() 5.0.3 Yes Yes Yes Yes Yes
VAR_SAMP() 5.0.3 Yes Yes Yes Yes Yes
VARIANCE() Yes Yes Yes Yes Yes
VERSION() Yes Yes Yes Yes Yes
WAIT_FOR_EXECUTED_GTID_SET() 5.7.5 Yes
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() 5.6.9 Yes Yes
WEEK() Yes Yes Yes Yes Yes
WEEKDAY() Yes Yes Yes Yes Yes
WEEKOFYEAR() Yes Yes Yes Yes Yes
WEIGHT_STRING() Yes Yes
Within() 5.7.6 Yes Yes Yes Yes Yes
X() 5.7.6 Yes Yes Yes Yes Yes
XOR Yes Yes Yes Yes Yes
Y() 5.7.6 Yes Yes Yes Yes Yes
YEAR() Yes Yes Yes Yes Yes
YEARWEEK() Yes Yes Yes Yes Yes