1
CREATE TABLE t1 (a IPV6);
2
INSERT INTO t1 VALUES ("fe8::b3ff:fe1a:8329");
3
INSERT INTO t1 VALUES ("FD01::1F");
4
INSERT INTO t1 VALUES ("::192.168.100.10");
5
INSERT INTO t1 VALUES ("::1");
8
0fe8:0000:0000:0000:0000:b3ff:fe1a:8329
9
fd01:0000:0000:0000:0000:0000:0000:001f
10
000:000:000:000:000:000:192.168.100.010
11
0000:0000:0000:0000:0000:0000:0000:0001
12
SELECT a FROM t1 WHERE a = "0fe8:0000:0000:0000:0000:b3ff:fe1a:8329";
14
0fe8:0000:0000:0000:0000:b3ff:fe1a:8329
15
SELECT a FROM t1 WHERE a LIKE "000:000:000:000:000:000:192.168.100.010";
17
000:000:000:000:000:000:192.168.100.010