MySQL Forums
Forum List  »  Newbie

Sql statement for finding ip addresses between 2 other ip addresses
Posted by: vanessa vercruysse
Date: March 24, 2005 01:13AM

Hi Everyone,

I have a problem. I want the possibility that people can find all the ip addresses between 2 ip addresses they give. I'll show the problem with an example.
10.10.5.10
10.10.21.10
10.10.60.10

When people say here for example give me the ip adresses between 10.10.21.10 and 10.10.60.10 they'll get all the ip adresses.
When they say between 10.10.5.10 and 10.10.60.10 Then they won't get the ip address 10.10.21.10. Now i think i have to split the ip addresses but i don't know how.
can someone help me?

Thx

Vanessa

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.