Thread: ORDER BY for how to sort numbers from 1 to 20 (not 01 to 20)?

How can we do differently to sort with numbers when retrieving data from a database?

Let me explain:

I create a list of IP addresses used. the results are like: 192.168.1, 192.168.2, 192.168.23

Even if I could specify ORDER BY to sort with only one party numbers (after the last point) I have the same problem.

Is there a solution (other methods for ORDER BY)?

Your application is in fact the only thing that good fishing is that you sort of string so they are well ordered, the normal sort.

There may be a sort option in sql that allows a different method. The same fate as the function Kingbird enphp or you can choose the sort method.

There are many possibilities! But not much simpler to sort of simple figures.

Thank you for your advice, and tested as soon as I find I can contact you. For now I have 2 Windows Server 2003 CD to install as in my business which is my priority.

For the processing of IP addresses, there are MySQL functions provided for this:

- Inet_aton () which converts an IP address into a 32bit integer.
- Inet_ntoa which is the inverse operation.