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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

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