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 results from this query. There are many services
called 'cafe' for example but I only want one.

R.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to