List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 13 1999 3:19am
Subject:Re: UNIQUE in a SELECT statement?
View as plain text  
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
Thread
UNIQUE in a SELECT statement?Hawke Robinson13 Jul
  • Re: UNIQUE in a SELECT statement?Sasha Pachev13 Jul