Re: SQL Select Unique() ?

In article <Pine.LNX.4.21.0105021106340.342-100000@presario>, anuradha@gnu.org (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