Order Ip Addresses in Sqlite3
I Would Like to Ask You How to Order Ip in Ascendant Way in Sqlite. I Tried Store Them Like Text and Integer, but It Doesn't Work. My Query Is: (Select * from...
I would like to ask you how to order IP in ascendant way in SQLITE. I tried store them like TEXT and INTEGER, but it doesn't work.
My query is:
(SELECT * FROM tbl_device ORDER BY ip ASC")
My output is:
192.168.1.1
192.168.1.10
192.168.1.11
192.168.1.111
192.168.1.12
192.168.1.120
Is there way to ORDER them like below:
192.168.1.1
192.168.1.10
192.168.1.11
192.168.1.12
192.168.1.111
192.168.1.120
Thank you very much in advance.
1 Answer
The easiest way to do this would be to store the IP addresses in a format that is sortable, i.e., as four numbers, or as a single 32-bit number. If you don't want to format the addresses every time they are displayed, use a separate column.
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
