I am currently creating a website on which I can add videos. When I add a video, I need to give a release date, formatted like: "21-09-2012".

Now, when I use the simple ORDER BY command, it only sorts on the first two digits.

Does anyone know how can I fix this?