sql - MYSQL select DISTINCT values in two columns

Question

I want to select distinct values in a database. Let me run you through a quick example.

Table:

foo bar
--- ---
a   c
c   f
d   a
c   a
f   c
a   c
d   a
a   c
c   a
f   c

Right, let's say my SQL is SELECT DISTINCT foo, bar from table. These are my results:

foo bar
--- ---
a   c
c   f
d   a
c   a
f   c

However the problem is is that there are repetitions of a c / c a just that they are in a different order. I don't want to select these, I want distinct values from both columns, please help!

Answer 1

How about using GROUP BY?

SELECT foo,bar FROM my_table GROUP BY foo,bar