mysql resource: Unique?

My small problem is that i need to figure out how to select only unique ip adresses from my hit counter table.

SELECT `ip` FROM `hitcounter`

? i know UNIQUE is recognized, but i cant seem to fit it in.

the big problem is that i have to post this stuff, because i cannot seem to find any good mysql resource like the one here for php
http://www.php.net/quickref.php

if you can help with either, thank you.

__________________
www.MonsterCoding.com - Website Programming and Development Services

Start here: http://mysql.com/

And the code your looking for is: select distinct ip from hitcounter;