MySQL
Store IPv4 and IPv6 Together in MySQL With INET6_ATON()
One column for both address families: INET6_ATON() and INET6_NTOA(), IPv4-mapped addresses, correct sorting, indexed range queries and MariaDB's native INET6 type.
Topic
ip-addresses
MySQL
Match an IPv4 Address Against a CIDR Subnet in MySQL
Store IPv4 addresses as INT UNSIGNED and test CIDR membership with a bitmask or, much faster on a big table, an indexed BETWEEN range on network and broadcast.
MySQL
ipcalc() in MySQL: Network, Broadcast and Prefix From a Netmask
Work out the network, broadcast address and prefix length of an IPv4 address inside a query, using INET_ATON(), INET_NTOA() and a little bitwise arithmetic.