Did You know that you can store ip addresses on mysql with no string handling? Well, I did not.
INSERT INTO ip_table ('ipv4') VALUES (INET_ATON("127.0.0.1"));
SELECT INET_NTOA('ipv4') FROM ip_table;
SELECT INET_NTOA('ipv4') FROM ip_table;
Well this does the trick, INET_ATON and INET_NTOA function transforms the ip address into his numeric value(Integer) and vice versa.
el_avena Off…