Kevin Waterson wrote:
This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
It looks as if you are looking to see if an address belongs to a
particular class B network. Are all your searches done that way?
If they are you may be able to use a regular expression to do your search.
well, the range could be 256, or 16, or 131072 or 2048 or any other number
really.
but the IP will always be a valid IPv4 address.
Given a valid IPv4 address, I wish to find the range it falls into.
eg: SELECT * FROM table WHERE start < 203.7.136.123 AND 203.7.136.123 < (start
plus range);
I guess the main issue is getting the start value plus the range value.
Kind regards
Kevin
Are you actually searching for membership in a class A, B or C network
or perhaps a subnet? If you are you can use the dotted format to your
advantage.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
