Querying mysql rows without including duplicates?

mysql, dupes, duplicates, distinct, query

[ShaunG]

How would I query only certain rows without including dupes when I am comparing 3 different columns? For example, there are 6 columns and I want to query for id, type, and date but since my db record dupes, I do not want to include any row that has the same type AND subid AND date.

[rocknbil]

Explore distinct [dev.mysql.com], this should provide a solution.

[ShaunG]

I am new to sql so I'm not sure why this would not work....it is returning empty set...

SELECT DISTINCT thedate, subid, thetype
FROM tablename
WHERE thedate=2009-04-03

[ShaunG]

nevermind i got it..i needed

WHERE thedate='2009-04-03'