docs/sql-manual/sql-functions/ip-functions/is-ip-address-in-range.md

{ “title”: “IS_IP_ADDRESS_IN_RANGE”, “language”: “en” }

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.

Example

mysql> SELECT is_ip_address_in_range('127.0.0.1', '127.0.0.0/8');
+----------------------------------------------------+
| is_ip_address_in_range('127.0.0.1', '127.0.0.0/8') |
+----------------------------------------------------+
|                                                  1 |
+----------------------------------------------------+

mysql> SELECT is_ip_address_in_range('::ffff:192.168.0.1', '::ffff:192.168.0.4/128');
+------------------------------------------------------------------------+
| is_ip_address_in_range('::ffff:192.168.0.1', '::ffff:192.168.0.4/128') |
+------------------------------------------------------------------------+
|                                                                      0 |
+------------------------------------------------------------------------+

mysql> SELECT is_ip_address_in_range('127.0.0.1', NULL);
+-------------------------------------------+
| is_ip_address_in_range('127.0.0.1', NULL) |
+-------------------------------------------+
|                                      NULL |
+-------------------------------------------+

Keywords

IS_IP_ADDRESS_IN_RANGE, IP