Echo distinct MySQL columns values?

[Len Whistler]

Any way to echo distinct MySQL column values? I can only see COUNT(DISTINCT column). Example:


Red
Blue
Green
Blue
Blue


Would echo as:


Red
Blue
Green

[guelphdad]

remove the count.

select distinct columnname from yourtablename

note that will only work for single columns, DISTINCT is not a function and works across all columns in a row.

for instance if you had

color1 and color2 as your columns and had the following values:

Orange Red
Orange Blue
Orange Green
Red Orange
Green Blue

all of those rows are distinct from one another so
select distinct color1, color2 from yourtablename
would return all of those rows.

[Len Whistler]

Thanks guelphdad........The code is working.