SELECT DISTINCT Colour FROM tablename Peter
On 14/02/2008, Richard <[EMAIL PROTECTED]> wrote: > > Hello, > > I don't know if it is possible to do this with mysql alone ... > Here goes : > I've got a database list which is like to following : > > Num | Name | Colour > ------------------------------------------- > 1 | Harry | Red > 2 | Tom | Blue > 3 | Jane | Green > 4 | Philip | Red > 5 | Sarah | Red > 6 | Robert | Blue > > > And from this table I wish to get a list of used colours. > > The correct answer would be : > > Colour > --------- > Red > Blue > Green > > The answer I don't want : > > Colour > -------- > Red > Blue > Green > Red > Red > Blue > > How would I achieve the first result with mysql ? Is it possible? > > > Thanks in advance, > > Richard > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >