Date: 03/21/06 (MySQL Communtiy)    Keywords: no keywords

Hi, can someone point me in the right direction?

If I do an "order by date" or "order by ip", my listings are indeed in an order, however if it is a date they would look like this:

1.23.05
1.24.06
10.23.02
11.24.23
12.33.02
2.23.02.
3......
And so on.

So it is just looking at the first numeral, rather than taking 10,11,&12 to be greater than 2 for example. What is this called? I don't know how to search for this. It also happens with IP addresses, or I guess anything where your numbers have a particular order to them.

Source: http://community.livejournal.com/mysql/90556.html