Mike, Try select * from foo order by x+0, x;
x+0 converts x to an integer by taking the digits from the beginning of the string. ========== original message follows ========== Date: Sat, 11 Dec 2004 15:36:34 -0600 From: Mike Blezien <[EMAIL PROTECTED]> To: MySQL List <[EMAIL PROTECTED]> Subject: ORDER BY sorting 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
