Need some help sorting in MySQL


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:

INSERT INTO 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

:cool: :cool: