IP Address Functions

Function List

ip_to_domain

This function checks whether the target IPv4 address is internal or external.

Syntax: ip_to_domain(expr)

Return value type: string

Example: SELECT IP_TO_DOMAIN('10.110.10.210'), IP_TO_DOMAIN('192.175.4.1')

ip_prefix

This field obtains the prefix of the target IPv4 address.

Syntax: ip_prefix(expr, prefixBit)

Return value type: string

Example: SELECT IP_PREFIX('10.110.10.210', 8), IP_PREFIX('144.101.32.5', 12)

is_prefix_subnet_of

This function checks whether the target IPv4 CIDR block is a subnet of a specified CIDR block.

Syntax: is_prefix_subnet_of(expr1, expr2)

Return value type: Boolean

Example: SELECT IS_PREFIX_SUBNET_OF('192.168.0.1/24', '192.168.1.1/24')

is_subnet_of

This function checks whether the target IPv4 address is in a specified CIDR block.

Syntax: is_subnet_of(expr1, expr2)

Return value type: Boolean

Example: SELECT IS_SUBNET_OF('192.168.0.1/24', '192.168.1.1')

ip_subnet_max

This function obtains the largest IP address in an IPv4 CIDR block.

Syntax: ip_subnet_max(expr)

Return value type: string

Example: SELECT IP_SUBNET_MAX('192.120.80.128/10')

ip_subnet_min

This function obtains the smallest IP address in an IPv4 CIDR block.

Syntax: ip_subnet_min(expr)

Return value type: string

Example: SELECT IP_SUBNET_MIN('192.120.80.128/10')

ip_subnet_range

This function obtains the range of an IPv4 CIDR block.

Syntax: ip_subnet_range(expr)

Return value type: string

Example: SELECT IP_SUBNET_RANGE('192.120.80.128/10')

When the maximum IP address, minimum IP address, and IP address range of a given CIDR block are calculated, its unicast and broadcast addresses are excluded. The maximum and minimum available IP addresses and the available IP address range of the CIDR block is returned.

ip_to_city

This function returns the city of an IPv4 address.

Syntax: ip_to_city(x)

Return value type: string

Example: select ip_to_city(ip)

ip_to_provider

This function returns the carrier name of an IPv4 address.

Syntax: ip_to_provider(x)

Return value type: string

Example: select ip_to_provider(ip)

ipv6_to_country

This function returns the carrier name of an IPv6 address.

Syntax: ipv6_to_country(x)

Return value type: string

Example: select ipv6_to_country(ip)

ipv6_to_country_code

This function returns the code of the country where an IPv6 address is located.

Syntax: ipv6_to_country_code(x)

Return value type: string

Example: select ipv6_to_country_code(ip)

ipv6_to_province

This function returns the name of the province where an IPv6 address is located.

Syntax: ipv6_to_province(x)

Return value type: string

Example: select ipv6_to_province(ip)

ipv6_to_city

This function returns the name of the city where an IPv6 address is located.

Syntax: ipv6_to_city(x)

Return value type: string

Example: select ipv6_to_city(ip)

ipv6_to_provider

This function returns the network service provider of an IPv6 address.

Syntax: ipv6_to_provider(x)

Return value type: string

Example: select ipv6_to_provider(ip)

ipv6_to_city_geo

This function returns the coordinates of the city where an IPv6 address is located.

Syntax: ipv6_to_city_geo(x)

Return value type: string

Example: select ipv6_to_city_geo(ip)

ipv6_to_geo

This function returns the coordinates of the city where an IPv6 address is located.

Syntax: ipv6_to_geo(x)

Return value type: string

Example: select ipv6_to_geo(ip)

ipv6_to_domain

This function checks whether the IP address is an intranet address.

Syntax: ipv6_to_domain(x)

Return value type: string

Example: select ipv6_to_domain(ip)