IS_IPV4

Syntax

IS_IPV4(expr)

Description

If the expression is a valid IPv4 address, returns 1, otherwise returns 0.

IS_IPV4() is stricter than INET_ATON(), but as strict as INET6_ATON(), in determining the validity of an IPv4 address. This implies that if IS_IPV4 returns 1, the same expression will always return a non-NULL result when passed to INET_ATON(), but that the reverse may not apply.

Examples

SELECT IS_IPV4('1110.0.1.1'); +-----------------------+ | IS_IPV4('1110.0.1.1') | +-----------------------+ | 0 | +-----------------------+  SELECT IS_IPV4('48f3::d432:1431:ba23:846f'); +--------------------------------------+ | IS_IPV4('48f3::d432:1431:ba23:846f') | +--------------------------------------+ | 0 | +--------------------------------------+

_{This page is licensed: CC BY-SA / Gnu FDL}