IS_IPV4() - Detecting IPv4 Address
Q
How to detect an IPv4 Address using the IS_IPV4() function?
✍: FYIcenter.com
A
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('10.0.5.9') | IS_IPV4('10.0.5.256') |
-- +---------------------+-----------------------+
-- | 1 | 0 |
-- +---------------------+-----------------------+
Reference information of the IS_IPV4() function:
IS_IPV4(ip): boolean
Returns 1 if and only if the argument is a valid IPv4 address.
Arguments, return value and availability:
ip: Required. The IP address to be examined.
boolean: Return value.
1 if and only if the argument is a valid IPv4 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_IPV4_COMPAT() - IPv4-Compatible IPv6 Address
⇐ IS_FREE_LOCK() - Checking Lock Status
2026-02-02, 3701🔥, 0💬
Related Topics:
