List:General Discussion« Previous MessageNext Message »
From:Gerald L. Clark Date:March 20 2001 8:38pm
Subject:Re: Best column type for an IP address
View as plain text  
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.
Thread
• How to put and get gziped file to/from mysql dbLeo.BOROVINSKY20 Mar
  • Re: How to put and get gziped file to/from mysql dbPeter Pentchev20 Mar
  • Re: How to put and get gziped file to/from mysql dbGerald L. Clark20 Mar
  • Best column type for an IP addressJason Bell20 Mar
  • Re: Best column type for an IP addressGerald L. Clark20 Mar