getting each different result only once

wxdqz

New Member
Hi

My Table:

|Producer|
|--------|
|ford|
|ford|
|ford|
|chrysler|

when I use "Select producer from table" I get 4 results (3x ford and 1x chrysler).

Is there a way that mysql checks whether the results are different, so I get 2 results (1x ford and 1x Chrysler)

thanks
Chris
 
Back
Top