Sortowanie IP Opcje

[Jaszczurr]

Jak posortowac adresy IP wpisane w bazie zeby byly wysietlane po koleii a nie
jakos dziwnie

100.140.154.7
100.140.154.9
100.140.154.11
100.140.154.12
100.140.154.13
100.140.154.55
100.140.154.56
100.140.154.105
100.140.154.58
100.140.154.59
100.140.154.5
100.140.154.8
100.140.154.10
100.140.154.32


czyli zeby np. 100.140.154.10 byl pod 100.140.154.9 itp.

[Jaszczurr]

Niestety sortuje zle

10.0.2.1 - Andrzej
10.0.2.10 - B
10.0.2.11 - W
10.0.2.13 - Dorota
10.0.2.15 - Joanna
10.0.2.16 - Joanna
10.0.2.17 - Stanislaw
10.0.2.18 - Krzysztof
10.0.2.19 - Wojciech
10.0.2.2 - Ania
10.0.2.20 - Alfred
10.0.2.21 - Irena
10.0.2.22 -
10.0.2.23 - Aga
10.0.2.24 -
10.0.2.25 - Jacek
10.0.2.26 - Damian
10.0.2.27 - Damian
10.0.2.28 - Marianna
10.0.2.29 - Arkadiusz
10.0.2.3 - Aleksandra
10.0.2.30 - Tomasz
10.0.2.31 -
10.0.2.32 -
10.0.2.33 - Henryk
10.0.2.34 -
10.0.2.35 -
10.0.2.4 - Piotr
10.0.2.41 -


SELECT * FROM user WHERE ip ORDER by ip