Re: SQL Select Unique() ?
| From: | Anuradha Ratnaweera | Date: | Wed, 02 May 2001 05:07:50 +0000 |
| Subject: | Re: SQL Select Unique() ? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-51108@lists.php.net to get a copy of this message | ||
On Thu, 19 Apr 2001, James, Yz wrote:
> Is there a method of extracting rows from a MySQL table Uniquely (as in only
> once) ?..... For example, when a user performs a search, using two words,
> it may return the same row twice if the search is spread over two or more
> SQL "selections". An example:
I am not sure whether you can do it on mysql. On postgresql you can do a
select distinct ...
Anuradha