majocmatt Posted March 15, 2007 Share Posted March 15, 2007 I have a list of country names in a database that is constantly being updated - countries are being added and deleted. It's for a client, and this is the way it has to be. My problem is getting USA to always be on top of the select dropdown list I populate on the admin page. Is this possible in a query? Can I ORDER BY countries in aplha order then force USA to be on top? I cannot order them by ID because, like I said, countries are coming and going, and it would screw up the order. I just need to know if it's possible in the query to do this? Thanks, Matt Quote Link to comment https://forums.phpfreaks.com/topic/42880-order-by-question/ Share on other sites More sharing options...
effigy Posted March 15, 2007 Share Posted March 15, 2007 ...ORDER BY IF(country='USA', 0, 1), country Quote Link to comment https://forums.phpfreaks.com/topic/42880-order-by-question/#findComment-208274 Share on other sites More sharing options...
fenway Posted March 15, 2007 Share Posted March 15, 2007 You can use order by field() as well... Quote Link to comment https://forums.phpfreaks.com/topic/42880-order-by-question/#findComment-208400 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.