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_IPV4() - Detecting IPv4 Address
- IS_IPV4_COMPAT() - IPv4-Compatible IPv6 Address
- IS_IPV4_MAPPED() - IPv4-Mapped IPv6 Address
- IS_IPV6() - Detecting IPv6 Address
⇒ IS_USED_LOCK() - Checking Lock Owner
⇐ IS_IPV4_MAPPED() - IPv4-Mapped IPv6 Address
2026-01-24, 3971🔥, 0💬
Related Topics:
