MySQL Other Functions

This page lists some MySQL functions that have no exact classification.

  1. ANY_VALUE

    The MySQL ANY_VALUE() function returns any value in the specified column. It is used in a GROUP BY statement to suppress errors caused by ONLY_FULL_GROUP_BY.

  2. BIN_TO_UUID

    The MySQL BIN_TO_UUID() function converts a specified binary UUID to a string UUID and returns the result.

  3. BINARY

    The MySQL BINARY operator converts a regular string to a binary string.

  4. CAST

    The MySQL CAST() function converts the parameter value ​​of any type to a value ​​of the specified type and return the result.

  5. COALESCE

    The MySQL COALESCE() function returns the first value in the parameter list that is not NULL.

  6. CONVERT

    The MySQL CONVERT() function converts the parameter value ​​of any type to the specified type or character set.

  7. DEFAULT

    The MySQL DEFAULT() function returns the default value for the specified column.

  8. INET_ATON

    The MySQL INET_ATON() function converts the specified IP address in a.b.c.d form to a numeric IP in network byte order.

  9. INET_NTOA

    The MySQL INET_NTOA() function converts a specified numeric IP in network byte order to an IP address in a.b.c.d form.

  10. INET6_ATON

    The MySQL INET6_ATON() function converts the specified IPv6 or IPv4 address to a binary string of numbers representing the address in network byte order.

  11. INET6_NTOA

    The MySQL INET6_NTOA() function converts the specified numeric IPv6 or IPv4 address to string form.

  12. IS_IPV4

    The MySQL IS_IPV4() function checks whether the given parameter is a valid IPv4 address.

  13. IS_IPV4_COMPAT

    The MySQL IS_IPV4_COMPAT() function checks whether a numeric IPv6 address is an IPv4-compatible IPv6 address.

  14. IS_IPV4_MAPPED

    The MySQL IS_IPV4_MAPPED()function checks whether a numeric IPv6 address is an IPv4-mapped IPv6 address.

  15. IS_IPV6

    The MySQL IS_IPV6() function checks whether the given parameter is a valid IPv6 address.

  16. IS_UUID

    The MySQL IS_UUID() function checks whether a given string is a valid UUID string.

  17. ISNULL

    The MySQL ISNULL() function checks whether the specified parameter is NULL.

  18. NAME_CONST

    The MySQL NAME_CONST() function are for MySQL internal use only and returns a given constant value with the specified column name.

  19. SLEEP

    The MySQL SLEEP() function pauses (sleeps) the current query for the specified number of seconds.

  20. UUID

    The MySQL UUID() function generates a Universally Unique Identifier (UUID) according to RFC 4122 and returns it.

  21. UUID_SHORT

    The MySQL UUID_SHORT() function returns a short universal identifier (64-bit unsigned integer) that is unique under certain conditions.

  22. UUID_TO_BIN

    The MySQL UUID_TO_BIN() function converts a specified string UUID to a binary UUID and returns the result.