Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting IP Addresses

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Anyone know any tricks to sorting IP Addresses? A normal sort will return:

192.168.100.1 before
192.168.3.1

Thanks.
 
Sort by date Sort by votes
try
select ipstring from table order by INET_ATON(ipstring)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CrystalChris
  • Locked
  • Question
Count Distinct (Per day) IP Addresses for a date range
Replies
1
Views
89
r937
r937
kp2a
  • Locked
  • Question
Select record where field contains a specific IP - mysql 1
Replies
13
Views
155
KarveR
KarveR
txwylde
  • Locked
  • Question
IP addresses with port numbers, need to extract class c addresses
Replies
3
Views
64
ingresman
ingresman
boske33
  • Locked
  • Question
problem with sorting id
Replies
3
Views
42
boske33
boske33
cihatkarli
  • Locked
  • Question
sorting rows
Replies
5
Views
69
cihatkarli
cihatkarli

Part and Inventory Search

Sponsor

Back
Top