Corporation
SW Florida's First ISP
- Original Message -
From: "Don Read" <[EMAIL PROTECTED]>
To: "Ralph" <[EMAIL PROTECTED]>
Cc: "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 4:38 AM
Subject: Re: Sorting Countries
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
On 25-Jun-2003 Ralph wrote:
> 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:
>
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 T
