SELECT DISTINCT 'Service type' FROM 'service_providers'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 20 April 2006 12:45
To: mysql@lists.mysql.com
Subject: getting unique results
SELECT `Service type` FROM `service_providers`
How do I get only unique resu
>
>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 - de