I'm using the MySQL code you see on this page to insert the country codes and names in my database. I've added the following extra line:
countries VALUES ('--', '(not listed)');
I'm using the following code to fetch the countries:
$result = @mysql_query("SELECT * FROM countries ORDER BY country ASC");
But the output always gives me (not listed) first and then the countries. I would like to see all the countries first, then the last output (not listed). Any one knows how I can do this in one MySQL statement?
ORDER BY CASE WHEN ccode = '--' THEN 'humpty' ELSE 'dumpty' END, ccode