2115 Built-In Function and Operator Reference Name Description Introduced Deprecated UpdateXML() Return replaced XML fragment UPPER() Convert to uppercase USER() The user name and host name provided by the client UTC_DATE() Return the current UTC date UTC_TIME() Return the current UTC time UTC_TIMESTAMP() Return the current UTC date and time UUID() Return a Universal Unique Identifier (UUID) UUID_SHORT() Return an integer-valued universal identifier UUID_TO_BIN() Convert string UUID to binary VALIDATE_PASSWORD_STRENGTH() Determine strength of password VALUES() Define the values to be used during an INSERT VAR_POP() Return the population standard variance VAR_SAMP() Return the sample variance VARIANCE() Return the population standard variance VERSION() Return a string that indicates the MySQL server version WAIT_FOR_EXECUTED_GTID_SET() Wait until the given GTIDs have executed on the replica. WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() Use WAIT_FOR_EXECUTED_GTID_SET() . 8.0.18 WEEK() Return the week number WEEKDAY() Return the weekday index WEEKOFYEAR() Return the calendar week of the date (1-53) WEIGHT_STRING() Return the weight string for a string XOR Logical XOR