Does mysql have a natural sort ability like php's natsort() function? I need to sort a bunch of dates in a natural order but instead they are going off of numbers.
Currently they are sorting like 1/1/04 , 1/12/04 , 1/2/04 , 1/22/04 etc.. I need them in their real order instead. Any ideas? Thanks!