title: MySQL, sort alphabetically with exception
body: <p>I have a table that is a list of countries, with two fields, ID (int) and country_name. I need to write a query that can pull an alphabetical list of countries, but with the United States record at the top. How can I do this? assume that the id of the united states record = 100.</p>