Built-In Function and Operator Reference Name Description Introduced Deprecated ICU_VERSION() ICU library version IF() If/else construct IFNULL() Null if/else construct IN() Whether a value is within a set of values INET_ATON() Return the numeric value of an IP address INET_NTOA() Return the IP address from a numeric value INET6_ATON() Return the numeric value of an IPv6 address INET6_NTOA() Return the IPv6 address from a numeric value INSERT() Insert substring at specified position up to specified number of characters INSTR() Return the index of the first occurrence of substring INTERNAL_AUTO_INCREMENT() Internal use only INTERNAL_AVG_ROW_LENGTH() Internal use only INTERNAL_CHECK_TIME() Internal use only INTERNAL_CHECKSUM() Internal use only INTERNAL_DATA_FREE() Internal use only INTERNAL_DATA_LENGTH() Internal use only INTERNAL_DD_CHAR_LENGTH() Internal use only INTERNAL_GET_COMMENT_OR_ERROR() Internal use only INTERNAL_GET_ENABLED_ROLE_JSON() Internal use only 8.0.19 INTERNAL_GET_HOSTNAME() Internal use only 8.0.19 INTERNAL_GET_USERNAME() Internal use only 8.0.19 INTERNAL_GET_VIEW_WARNING_OR_ERROR() Internal use only INTERNAL_INDEX_COLUMN_CARDINALITY() Internal use only INTERNAL_INDEX_LENGTH() Internal use only INTERNAL_IS_ENABLED_ROLE() Internal use only 8.0.19 INTERNAL_IS_MANDATORY_ROLE() Internal use only 8.0.19 INTERNAL_KEYS_DISABLED() Internal use only INTERNAL_MAX_DATA_LENGTH() Internal use only INTERNAL_TABLE_ROWS() Internal use only INTERNAL_UPDATE_TIME() Internal use only 2101