In message <[EMAIL PROTECTED]>, Pete <[EMAIL PROTECTED]> writes > >I have mytable with myfield containing 0,1,2,3,4... > >I want to display the records in the order 1,2,3,4... 0. > >That is, records containing 0 comes AFTER the records with a value.
Gosh, I feel clever <G> - figured it out - it's: SELECT myfield from mytable ORDER BY not(myfield), myfield; -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
