assuming you have a table with two columns id and town then here's one solution:
> Create temporary table address (ad varchar(30)); > Insert into address select concat(id, ' ', town) from your_original_table_name; > select * from address order by ad; --- Nicolas JOURDEN <[EMAIL PROTECTED]> wrote: > Hi, > > How can I fix an order by using numbers and letters > ? > > Id Town > 56 Paris 1 > 60 Paris 10 > 7 Paris 11 > 262 Paris 12 > 8 Paris 13 > 16 Paris 14 > 22 Paris 15 > 6 Paris 3 > 57 Paris 4 > 51 Paris 6 > 5 Paris 7 > 61 Paris 8 > 59 Paris 9 > > I'd like to get : > > 56 Paris 1 > 6 Paris 3 > 57 Paris 4 > 51 Paris 6 > 5 Paris 7 > 61 Paris 8 > 59 Paris 9 > 60 Paris 10 > 7 Paris 11 > 262 Paris 12 > 8 Paris 13 > 16 Paris 14 > 22 Paris 15 > > A this time I'm doing this sql syntax : > > SELECT * > FROM town > ORDER BY town ASC > > > How can I do it ? > > > > --------------------------------------------------------------------- > 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 > __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com --------------------------------------------------------------------- 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