[thelist] sql order by sizes

Brian Cummiskey brian at hondaswap.com
Sat Jul 7 17:10:56 CDT 2007


I have a table with size info like the following:

2XL
XL
Med
Sm
Lg
4XL
2XL

etc


I'm trying to devise a way to display these in order by size, so that it 
goes smallest through largest (sm - 4XL)


There's no id in order or anything else to logically sort by.


Anyone ever work with this before?  

I'm trying to avoid creating a sizeOrder table and adding another join 
if possible.



More information about the thelist mailing list