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]