ordenar por ip una lista

[huesos52]

Con los datos que pones de prubeas, la primera opción de gnzsoloyo funciona bien.

Código mysql:

mysql> select *from internet_protocol;
+-----------------+
| ip              |
+-----------------+
| 12.120.14.1     |
| 12.120.14.106   |
| 12.120.14.16    |
| 12.120.14.56    |
| 192.168.194.168 |
+-----------------+
5 rows in set (0.00 sec)
 
mysql> SELECT ip
    -> FROM internet_protocol
    -> GROUP BY ip
    -> ORDER BY INET_ATON(ip) desc;
+-----------------+
| ip              |
+-----------------+
| 192.168.194.168 |
| 12.120.14.106   |
| 12.120.14.56    |
| 12.120.14.16    |
| 12.120.14.1     |
+-----------------+
5 rows in set (0.00 sec)
 
mysql> SELECT ip
    -> FROM internet_protocol
    -> GROUP BY ip
    -> ORDER BY INET_ATON(ip) asc;
+-----------------+
| ip              |
+-----------------+
| 12.120.14.1     |
| 12.120.14.16    |
| 12.120.14.56    |
| 12.120.14.106   |
| 192.168.194.168 |
+-----------------+
5 rows in set (0.02 sec)
 
mysql>
 

Que problema estas teniendo?