Handle IP and IP number in MySQL
You can use int unsigned for storing IP address (like 127.0.0.1) in MySQL.
But HOW ???
INET_ATON() and INET_NTOA() Functions in MySQL will help you....
Store the converted IP number as int unsigned in MySQL using INET_ATON() and get the exact IP addess by using INET_NTOA()