MySQL Help - Date Issues

[noonespecial]

I have a column of dates (field93) in this format:

MMDDYY

Currently I am using:

ORDER BY field93 DESC

However, with the new year - this doesn't work because:

120108 shows up before 010709

How can I fix this?

[Marco van Herwaarden]

You should not store it in this format. This is why most software stores date like (YY)YYMMDD, so it can be sorted.

[Bellardia]

You should convert your dates like Marco said so you can use a reliable search method.
I can't think of any way to generally find what your looking for without searching for specific smal intervals.

[Marco van Herwaarden]

Yes you could sort by substrings, but that could easily become a performence killer.