How to compare IPV6 address in SQL

Question

Here is the IPV6 address in a table in SQL database, I want to compare these two IPV6 addresses From Range: 2002:4559:1FE2:4559:1FE2:21E3:F3E3:0051
To Range: 2002:4559:1FE2:4559:1FE2:21E3:F3E3:0055 Need to compare those addresses and then update the To range address to the From range address in that table.Please help

there are other options than this two? In future? Or only two addresses to make that range? — Whencesoever, Mar 01 '17 at 07:39

score 1 · Answer 1 · edited May 23 '17 at 12:32

1

If you're using MySQL >5.6.3, you could use INET6_ATON to convert the string to a VARBINARY(16) and use that for a range check? A lexicographical string comparison might also work for you if these are addresses are all stored in a uniform way.

See also Storing IPv6 Addresses in MySQL

edited May 23 '17 at 12:32

Community

1
1

answered Mar 01 '17 at 07:41

Paul Dixon

295,876
54
310
348

Thanks for the reply,But i didnt get you sir,COuld you plz write a querey instead – p.v.g Sagar Mar 01 '17 at 08:40

score -1 · Answer 2 · edited Sep 10 '17 at 05:10

-1

Calculates an MD5 128-bit checksum for the two ranges and compare the checksum instead the ranges. The value(checksum) is returned as a string of 32 hexadecimal digits, or NULL if the argument was NULL.

Sample query:

UPDATE Table T1
SET T1.To_Range = T1.From_Range
WHERE MD5(T1.From_Range) !=  MD5(T1.To_Range)

edited Sep 10 '17 at 05:10

simhumileco

31,877
16
137
115

answered Mar 01 '17 at 08:12

narendra solanki

374
2
8

Does this MD5 compares the IPV6 addresses? – p.v.g Sagar Mar 01 '17 at 08:43
which database are you using? – narendra solanki Mar 01 '17 at 11:59
Im using MySql database – p.v.g Sagar Mar 03 '17 at 11:43

How to compare IPV6 address in SQL

2 Answers2