IS_IP_ADDRESS_IN_RANGE

SinceVersion dev

IS_IP_ADDRESS_IN_RANGE

description

Syntax

BOOLEAN IS_IP_ADDRESS_IN_RANGE(STRING ip_str, STRING cidr_prefix)

Determine whether the IP (IPv4 or IPv6) address is included in the network represented by CIDR notation. If yes, return true; otherwise, return false.

notice

ip_str and cidr_prefix both cannot be NULL

example

1. mysql> SELECT is_ip_address_in_range('127.0.0.1', '127.0.0.0/8');
2. +----------------------------------------------------+
3. | is_ip_address_in_range('127.0.0.1', '127.0.0.0/8') |
4. +----------------------------------------------------+
5. |                                                  1 |
6. +----------------------------------------------------+

8. mysql> SELECT is_ip_address_in_range('::ffff:192.168.0.1', '::ffff:192.168.0.4/128');
9. +------------------------------------------------------------------------+
10. | is_ip_address_in_range('::ffff:192.168.0.1', '::ffff:192.168.0.4/128') |
11. +------------------------------------------------------------------------+
12. |                                                                      0 |
13. +------------------------------------------------------------------------+

keywords

IS_IP_ADDRESS_IN_RANGE, IP