Some help with a query!

[itandme]

Hello there!

I got a mysql table where whisky distilleries are listed with locations, as country and region.

What I want is to list all countrys/regions with distilleries... How do I do this?

Say if i just run a query with the countries as output, I will get something like:

Scotland
Scotland
Scotland
England
USA
USA
Scotland
Sweden
USA

But what I want is just to get a list of countries that we/the database got distilleries in.
As:

Scotland
England
USA
Sweden

Arr you get it :p

Thx!

[LordShryku]

SELECT DISTINCT country
FROM TABLE

[itandme]

Thanks!

AND I DID LOOK IN THE MANUAL!

[LordShryku]

I never said you didn't :p