Hi, On Wed, Sep 10, 2003 at 09:07:30AM -0400, Mark Riehl wrote: > All - We're using MySQL under Linux to store data collected during network > tests. One of our columns store the integer representation (in network byte > order) of an IP address. > > Is there any current support in MySQL (or future planned support) to convert > from the integer representation of an IP address to a dotted quad (e.g., > 192.168.1.1) representation. Currently, we're doing this with a Perl script > as part of our post test analysis. >
Look for INET_NTOA / INET_ATON in the manual. Make sure your fields are unsigned ints. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]