Developers

Create table


Mysql

Microsoft SQL

Load data


Mysql

Microsoft SQL

Download BasicIPv4.fmt
Download PremiumIPv4.fmt
Download UltimateIPv4.fmt
Download BasicIPv6.fmt
Download PremiumIPv6.fmt
Download UltimateIPv6.fmt

IP Address to IP Number conversion


PHP

The function ip2long() generates an IPv4 Internet network address from its Internet standard format (dotted string) representation. See example

Perl

 C#

T-SQL

IP Number to IP Address conversion


PHP

The function long2ip() generates an Internet address in dotted format (i.e.: aaa.bbb.ccc.ddd) from the proper address representation.

Perl

 C#

 T-SQL

Query the database


MySQL

Convert IP address to IP number first

Or let mysql convert the address to number for you:

Microsoft SQL