I havn't followed the whole thread, but from what I understand you store the data as numbers and not IP-strings. The most common way of checking a range is to use a IP-mask, and this should work fine in this case as well.
Something like:
SELECT * FROM myiptable WHERE (ip & "maskvalue") == ("subnet IP" & "maskvalue")

the maskvalue in this case could be something like 255.255.255.0 (decimal value 4294967040) to check the subnet



Kevin Waterson wrote:
How can I SELECT an IP within a range?
All my IP's are stored as 1.2.3.4 but I need to check if
each is within a range of long IP's.

Can this be done with SQLite? or do I need some sort of
external ip2long() function to throw at it?

Kind regards
kevin


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to