MySql Help DISTINCT

Databases
1

I have a table:

[myTable]
ID
Name
HairColor
NumberOfPairsOfPants
I can easily get a list of HairColor with

SELECT DISTINCT HairColor FROM myTable
But I want the full contents the records where the hair color is Distinct (Yes the database table is denormalized/redundant so I don’t get logic errors)

Pseudo code

SELECT DISTINCT HairColor,* FROM myTable

Syntax help!

2

Try Group By instead of Distinct

3

Cant see you get there without Grouping/Max and DISTINCTROW

4 
select * 
  from mytable a
where exists (SELECT 8
              FROM mytable B
             where a.haircolor=b.haircolor
             group by haircolor
             having count(b.haircolor)=1;

off the top of my head… untested.

6 
select * 
  from mytable a
where exists (SELECT haircolor
              FROM mytable B
             where a.haircolor=b.haircolor
             group by haircolor
             having count(b.haircolor)=1;

forgot group by needed the field in the select part

this would return Jenny as she is the only one with Red hair, 3 have Black, 2 have Brown

7

Thanks Guys!