From: Date: March 20 2001 8:38pm
Subject: Re: Best column type for an IP address
List-Archive: http://lists.mysql.com/mysql/68899
Message-Id: <3AB7B1A1.CFEA0C57@suppliersystems.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Jason Bell wrote:
> 
> Hello all!
> 
> Does  MySQL have a function that converts an IP address from dotted decimal to binary, and back
> again?
> 
> Jason Bell
> 
INET_NTOA
INET_ATON

I'll leave it as an exercise to you to read Manual Chapter 7.4.12.