Code Forums - View Single Post

Odoggy5 · 10-06-2005, 03:46 PM

I am using a character field in one of my tables(MySQL) and using numbers in that field also how can make the #'s come out in numerical order?

ex.

cnfg1, cnfg2, cnfg3...cnfg10, cnfg11, cnfg12

my query sorts them like

cnfg1, cnfg10, cnfg11, cnfg12, cnfg2, cnfg20, cnfg21...

i want them like

cnfg1, cnfg2, cnfg3, cnfg4,...cnfg11, cnfg12, cnfg13

is there a way for me to do that or will i have to have seperate fields?

10-06-2005, 03:46 PM	#1 (permalink)
Odoggy5 Code Monkey Join Date: Aug 2003 Location: SF Posts: 47	sorting question I am using a character field in one of my tables(MySQL) and using numbers in that field also how can make the #'s come out in numerical order? ex. cnfg1, cnfg2, cnfg3...cnfg10, cnfg11, cnfg12 my query sorts them like cnfg1, cnfg10, cnfg11, cnfg12, cnfg2, cnfg20, cnfg21... i want them like cnfg1, cnfg2, cnfg3, cnfg4,...cnfg11, cnfg12, cnfg13 is there a way for me to do that or will i have to have seperate fields?