跳到主要内容
跳到主要内容

IS_IPV4_STRING

IS_IPV4_STRING

IS_IPV4_STRING

Description

Syntax

BOOLEAN IS_IPV4_STRING(STRING ipv4_str)

接收一个表示形式为字符串的IPv4地址作为参数,如果为格式正确且合法的IPv4地址,返回true;反之,返回false。

Example

mysql> select is_ipv4_string(NULL);
+----------------------+
| is_ipv4_string(NULL) |
+----------------------+
| NULL |
+----------------------+

mysql> CREATE TABLE `test_is_ipv4_string` (
`id` int,
`ip_v4` string
) ENGINE=OLAP
DISTRIBUTED BY HASH(`id`) BUCKETS 4
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);

mysql> insert into test_is_ipv4_string values(0, NULL), (1, '0.0.0.'), (2, ''), (3, '.'), (4, '255.255.255.255');

mysql> select id, is_ipv4_string(ip_v4) from test_is_ipv4_string order by id;
+------+-----------------------+
| id | is_ipv4_string(ip_v4) |
+------+-----------------------+
| 0 | NULL |
| 1 | 0 |
| 2 | 0 |
| 3 | 0 |
| 4 | 1 |
+------+-----------------------+

Keywords

IS_IPV4_STRING, IP