In article <Pine.LNX.4.21.0105021106340.342-100000@presario>,
 [EMAIL PROTECTED] (Anuradha Ratnaweera) 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 ...

The "distinct" keyword also works in mysql (the manual at mysql.com 
provides details).

-- 
CC

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to