IS_IP_ADDRESS_IN_RANGE

IS_IP_ADDRESS_IN_RANGE

Description

Syntax

BOOLEAN IS_IP_ADDRESS_IN_RANGE(STRING ip_str, STRING cidr_prefix)

判断IP（IPv4或IPv6）地址是否包含在以CIDR表示法表示的网络中。如果是，则返回true，否则返回false。

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. +------------------------------------------------------------------------+
  15. mysql> SELECT is_ip_address_in_range('127.0.0.1', NULL);
  16. +-------------------------------------------+
  17. | is_ip_address_in_range('127.0.0.1', NULL) |
  18. +-------------------------------------------+
  19. |                                      NULL |
  20. +-------------------------------------------+

Keywords

IS_IP_ADDRESS_IN_RANGE, IP