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]
-----------------------------------------------------------------------------