MySQL IP V4 and V6

example.sql

CREATE TABLE `my_ip` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip_addr` varbinary(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `my_ip` (`ip_addr`) VALUES (INET6_ATON(?)); // For IP V6
INSERT INTO `my_ip` (`ip_addr`) VALUES (INET_ATON(?)); // For IP V4

SELECT 
	IF(INET_NTOA(ip_addr) IS NULL OR INET_NTOA(ip_addr) = '0.0.0.0', INET6_NTOA(ip_addr), INET_NTOA(ip_addr)) as ip
FROM my_ip WHERE 1 = 1;