List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:December 11 2004 9:36pm
Subject:ORDER BY sorting
View as plain text  
Hello,

I'm trying to figure out how sort a column alphabetically, but some of the 
values start with a numerical value. So when I do the ORDER BY column_name all 
the values starting alphabeticlly are listed first, then the numerical values 
after that.. can this be done in a single query..

MySQL ver. 4.0.20

TIA,
-- 
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://thunder-rain.com/
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Thread
ORDER BY sortingMike Blezien11 Dec
Re: ORDER BY sortingBill Easton13 Dec