Hawke Robinson wrote:
>
> I'm trying to compare values from a columns and not display replications
> of the same values, I tried the following syntax and received an error,
> and can't find anything on the SQL word UNIQUE in the MySQL online
> manual. Any help for this (hopefully simple) issue would be appreciated.
>
> Syntax tried:
> SELECT StateProv FROM GamerFinder WHERE UNIQUE;
> also tried (probably WAY off)
> SELECT StateProv FROM GamerFinder WHERE UNIQUE(SELECT StateProv FROM
> GamerFinder);
>
> Thanks.
>
SELECT DISTINCT StateProv FROM GamerFinder;
>
--
Sasha Pachev
http://www.sashanet.com
