List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:April 20 2006 11:48am
Subject:Re: getting unique results
View as plain text  

>SELECT `Service type` FROM `service_providers`
>How do I get only unique results from this query. There are many services
called 'cafe' for example but I only want one.

Well, this could help:

select distinct `service type` FROM `service_providers`

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!

getting unique resultsross20 Apr
  • Re: getting unique resultsMartijn Tonies20 Apr
  • RE: getting unique resultsSteve Giller20 Apr