Nicolas, > How can I fix an order by using numbers and letters ? > Id Town > 56 Paris 1 > 60 Paris 10 > 7 Paris 11 > I'd like to get : > 56 Paris 1 > 6 Paris 3 > 57 Paris 4 > A this time I'm doing this sql syntax : > SELECT * > FROM town > ORDER BY town ASC
SELECT * FROM town ORDER by town ASC, district ASC Assuming that you have district in a different column. If not, you're database design is somewhat not optimal, and you should change it. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 --------------------------------------------------------------------- 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