Scott, This may not be your exact solution, but if your network address is 24 bit then you could just check against the last octet, i.e. x >= 10 and x =< 100.
James --- Scott Haneda <[EMAIL PROTECTED]> wrote: > Given a IP range such as: > 12.8.197.10 -> 12.8.197.100 > > I want to store those 2 values in a database, before > I insert a new value, I > would like to test for the new values existence. > > Any idea what I should convert a IP address into in > order to be able to > operate on it with simple greater than, less than > and equal to math? > -- > -- > ------------------------------------------------------------- > Scott Haneda Tel: > 415.898.2602 > <http://www.newgeo.com> Fax: > 313.557.5052 > <[EMAIL PROTECTED]> Novato, > CA U.S.A. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]