UNIQUIE returned only with SELECT

[Pests]

I need a way to only return UNIQUIE rows from MySQL, but only for one column. For example, with this table I want only records that have a UNIQUIE name:

id|name|animal
1|Jack|fish
2|Mark|dog
3|Mark|duck
4|John|cat
5|Mark|bear
6|Jack|bird

The records that should be returned would be: 1, 2, 4. I can't make the name column UNIQUIE in the database since its all possbile for them to be in there more then once, but i want a list of all the names there are without duplicates.

[ahundiak]

SELECT DISTINCT name FROM animals;

[Pests]

Dammit, I found the DISTINCT in the mysql manual but I didn't know you put the feild name after it. Thanks alot.

[TheIceman5]

Originally posted by Pests
Dammit, I found the DISTINCT in the mysql manual but I didn't know you put the feild name after it. Thanks alot.

it aint gonna know what field to return otherwise.

[Pests]

I mean, I thought that is was just a keyword put inside of it and the column names after it have noting to do with it.