Finally, i found a way to convert it, thanks to this blogpost i found from Google. Hope it will helps you too developer of the world.
Link-back: http://arjen-lentz.livejournal.com/44290.html
mysql > SELECT INET_ATON('192.168.0.10') AS ipn; +------------+ | ipn | +------------+ | 3232235530 | +------------+ mysql > SELECT INET_NTOA(3232235530) AS ipa; +--------------+ | ipa | +--------------+ | 192.168.0.10 | +--------------+
You can test to convert back-to-back from ip address to hostname using tool from this website: http://www.hcidata.info/host2ip.cgi
Good luck!
Related posts:

