IS_IPV6() - Detecting IPv6 Address

Q

How to detect an IPv4 Address using the IS_IPV6() function?

✍: FYIcenter.com

A

IS_IPV6(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv6 address, 0 otherwise. For example:

SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256');
  -- +---------------------+-----------------------+
  -- | IS_IPV4('10.0.5.9') | IS_IPV4('10.0.5.256') |
  -- +---------------------+-----------------------+
  -- |                   1 |                     0 |
  -- +---------------------+-----------------------+

Reference information of the IS_IPV6() function:

IS_IPV6(ip): boolean
  Returns 1 if and only if the argument is a valid IPv6 address.

Arguments, return value and availability:
  ip: Required. The IPv6 address to be examined.
  boolean: Return value. 
    1 if and only if the argument is a valid IPv6 address.
  Available since MySQL 4.0.

Related MySQL functions:

⇒ IS_USED_LOCK() - Checking Lock Owner

⇐ IS_IPV4_MAPPED() - IPv4-Mapped IPv6 Address

⇑ MySQL Functions for Miscellaneous Purposes

⇑⇑ MySQL Function References

2026-01-24, 4116🔥, 0💬

INET6_NTOA() - IPv6 Address Number to String
How to convert an IPv6 address from number format to string using the INET6_NTOA() function? INET6_NTOA(int) is a MySQL built-in function that converts an IPv6 address from number format to string. For example: SET @ipv6 = UNHEX('FDFE0000000000005A55CAF FFEFA9089');SELECT HEX(@ipv6), INET6_NTOA(@ipv... 2026-02-02, 3798🔥, 0💬

UPDATEXML() - Updating Child Element in XML
How to update a child element in an XML document at a given location using the UPDATEXML() function? UPDATEXML(xml, path, subxml) is a MySQL built-in function that updates a child element in an XML document at a given location. For example: SET @xml = ' X Y '; SELECT UPDATEXML(@xml, '/a', ' Z '); +-... 2026-01-24, 3605🔥, 0💬

IS_IPV4() - Detecting IPv4 Address
How to detect an IPv4 Address using the IS_IPV4() function? IS_IPV4(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv4 address, 0 otherwise. For example: SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256'); -- +---------------------+------- ----------------+-- | IS_IPV4... 2026-02-02, 3402🔥, 0💬

IS_IPV4_COMPAT() - IPv4-Compatible IPv6 Address
How to detect an IPv6 Address that is IPv4 compatible using the IS_IPV4_COMPAT() function? IS_IPV4_COMPAT(ip) is a MySQL built-in function that returns 1 if the given IPv6 address is IPv4-compatible, 0 otherwise. The IPv6 address must be given in number format. An IPv4-compatible IPv6 address has 12... 2026-02-02, 2730🔥, 0💬

VALUES() - Column Value for "ON DUPLICATE KEY UPDATE"
How to obtain the inserting value of given column in the "ON DUPLICATE KEY UPDATE" clause using the VALUES() function? VALUES(col) is a MySQL built-in function that returns the inserting value of a given column and use it in the "ON DUPLICATE KEY UPDATE" clause. For example: CREATE TABLE MyTable (id... 2025-10-24, 2655🔥, 0💬

SLEEP() - Holding Statement Execution
How to hold the statement execution for some time using the SLEEP() function? SLEEP(sec) is a MySQL built-in function that holds the execution of the current statement for sec seconds. For example: SELECT SYSDATE(), SLEEP(2), SYSDATE(); -- +---------------------+------- ---+---------------------+-- ... 2023-12-19, 1774🔥, 0💬

LEAST() - Finding the Least/Minimum Value
How to find the least (minimum) value of a given list of values using the LEAST() function? LEAST(val1, val2, ...) is a MySQL built-in function that returns the least (minimum) value of a given list of values. For example: SELECT LEAST(70, 89, 73, 99, 101, 110, 116, 101, 114); -- +------------------... 2023-12-19, 1740🔥, 0💬

INET6_ATON() - IPv6 Address String to Number
How to convert an IPv6 address from string format to number using the INET6_ATON() function? INET6_ATON(ip) is a MySQL built-in function that converts an IPv6 address from string format to number. But an IPv6 number is too big to be represented in decimal digits. So it is stored as a byte sequence, ... 2026-04-13, 1680🔥, 0💬

NULLIF() - NULL on Equal Values
How to generate NULL with equal values using the NULLIF() function? NULLIF(val1, val2) is a MySQL built-in function that returns NULL if the first argument equals the second, the first argument otherwise. For example: SELECT NULLIF('yes', 'yes'), NULLIF('yes', 'no'); -- +----------------------+-----. .. 2023-12-19, 1588🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.