Hi, SELECT .... FROM table ORDER BY short_description+0; will do it..
Gurhan -----Original Message----- From: Steve Buehler [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 4:41 PM To: mysql Subject: Order by Is there a way to use "ORDER BY", or something else, that will order the following in numerical order instead of alphabetical order? The column that the data is in is: short_description varchar(20) default NULL. 21UG3 10UB5 100UB6 1UG1 The way it comes out with "ORDER BY" is: 1UG1 10UB5 100UB6 21UG3 I need it to be: 1UG1 10UB5 21UG3 100UB6 I use PHP to access the mysql database so if MySQL can't do it, does anybody know of a way to do it in combination with PHP? Thanks in advance Steve --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php