IS_IPV4_MAPPED() function in MySQL

IS_IPV4_MAPPED() :

This function in MySQL takes an IPv6 address represented in numeric form as a binary string, as returned by INET6_ATON function. If the argument is a valid IPv4-mapped IPv6 address it returns 1, It returns 0 otherwise. The general form of IPv4-mapped addresses is ::ffff:ipv4_address.

Syntax :

IS_IPV4_MAPPED(expr)

Parameter : 

This function accepts one argument.

• expr – Input IPv6 address represented by a string.

Returns : 

• It returns 1 if the string is a valid IPv4-mapped IPv6 address. 
• If the string is not a valid IPv4-mapped IPv6 address then it will return 0.  

Example-1 :

Checking whether the given address “::12.10.15.8” is valid or not using IS_IPV4_MAPPED Function. As given input is not a valid IPv4-mapped address here, it will return 0.

SELECT IS_IPV4_MAPPED(INET6_ATON('::12.10.15.8')) AS IS_IPV4_MAPPED ;

Output :

IS_IPV4_MAPPED
0

Example-2 :

Checking whether the given address “::ffff:8.7.12.3” is valid or not using IS_IPV4_MAPPED Function. As the given input is a valid IPv4-mapped address here, it will return 1.

 SELECT IS_IPV4_MAPPED(INET6_ATON('::ffff:8.7.12.3')) AS IS_IPV4_MAPPED;

Output :

IS_IPV4_MAPPED
1

Example -3 :

Checking whether the given address “ff::9.6.10.11” is valid or not using IS_IPV4_MAPPED Function. As the given input is not a valid IPv4-mapped address here, it will return 0.

SELECT IS_IPV4_MAPPED(INET6_ATON('ff::9.6.10.11')) AS IS_IPV4_MAPPED ;

Output :

IS_IPV4_MAPPED
0

Example-4 :

Checking whether the given IPv6 address “::1″ is valid or not using IS_IPV4_MAPPED Function

SELECT IS_IPV4_MAPPED(INET6_ATON('::1')) AS IS_IPV4_MAPPED;

Output :

IS_IPV4_MAPPED
0