Re: Sort and remove duplicates

In article <1190985054.159629.205280@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,
JimJx <webmaster@xxxxxxxxxxxxxxxx> wrote:

: I have a db (MySQL) that I need to sort on the first field and
: remove dups from.
:
: For example, let's say I have Red,1,2,3,4,5 and Blue,1,2,3,4,5
: and Green,1,2,3,4,5 and Green,2,2,2,2,2
:
: How can I come out with Blue,1,2,3,4,5;Green,1,2,3,4,5;
: Red,1,2,3,4,5??

Why does the Green row get 1,2,3,4,5 on the output?

Greg
--
The list of stable paper currencies built by central bankers is as
short as the list of stable democracies built by armed invaders.
-- Bill Bonner
.