Re: mysql parsing hex to make an ip address

try using inet_ntoa() function. On Thu, 23 Aug 2001 12:19:54 -0700 Jamil Farshchi <[EMAIL PROTECTED]> wrote: > Hello, > > I am trying to convert a hex number that is stored in a mysql db into an ip > address. Here is my problem: I can convert the original integer into a hex > number like so:

mysql parsing hex to make an ip address

Hello, I am trying to convert a hex number that is stored in a mysql db into an ip address. Here is my problem: I can convert the original integer into a hex number like so: For example: mysql> select distinct HEX(ip_src) from iphdr; --- |ip_src| ---| |80B7EB99 | |