Hi,
I need to be able to store data from our Radius servers that includes IP
addressing and IP blocks into a MySQL field that is easily searchable.
Basic IP addreses I have sorted with INET_ATON(), but is there a way to
store blocks of IP's as in "192.168.1.0/24" in a way that would allow it to
be found in a search for say 192.168.1.100? Perhaps a method to take the
block and insert the 1st and last IP's into seperate columns so I can check
to see if it falls between these 2 values?
The import of Radius into MySQL is performed by doing a 'LOAD DATA LOCAL
INFILE' on a CSV file. Ideal would be a solution to insert the 1st and last
IP address based on the IP block at the time of doing the LOAD?
Thanks.
Jim.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]