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