insert one space before US ;) in recieving do trim if not HTML output
-----Original Message----- From: Ralph [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 7:32 AM To: mySQL Mailing List Subject: Sorting Countries I am getting a list of all countries from database, and then I am sorting by country name. However since most orders will be from US I want the US to appear first over the rest of the countries. How can I go about doing this? Currently, this is my query: SELECT countries_id, countries_name FROM TABLE_COUNTRIES ORDER BY countries_name; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]