Menu

MySQL Other Functions

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

  1. ANY_VALUE

    Learn when MySQL ANY_VALUE() can suppress ONLY_FULL_GROUP_BY checks, why its result may be arbitrary, and when to use a deterministic alternative.

  2. BIN_TO_UUID

    MySQL BIN_TO_UUID() converts a 16-byte binary UUID to text. Use the same swap_flag value that was used by UUID_TO_BIN().

  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

    MySQL UUID() generates a version 1 UUID. Learn its format, host information, and statement-based replication caveat.

  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

    MySQL UUID_TO_BIN() converts a string UUID to 16-byte binary data. Learn when swap_flag helps and how to reverse it correctly.