return only distinct matches

[dswimboy]

I have a table with three Keys. riverID (Primary), river name, and state. I want to list all the states that have rivers in them. the following query returns states multiple times, becuase there are multiple rivers in each state.
SELECT `state`
FROM `rivers`What do I do to return the states that have rivers in them ony once?

If you don't understand my question, please ask for an example. If you do understand my question and know I'm not describing properly, please help me describe it.

[Sayonara]

SELECT DISTINCT 'field_name'

:)

[dswimboy]

how wonderfully simple. this forum is excellent for stupid little questions like this

[Sayonara]

Isn't it nice when a language uses a sensible word for a command?