MySQL getting distinct data from multiple columns?

[Vaastav]

Hi, I have got 4 columns with data in and I want select all the distinct data from each column and display it in a table. How do I go about doing this.

Heres an exmaple of what my Columns in my table are like:-
Column1 Column2
0 this is empty
this is empty 1
0 0
0 this is empty

Output should be something like this:-
0
1
0
0

Thanks for your help in advance.

 

[sleipnir214]

Your question and example table are ambiguous. Given the following table:

[tt]+---------+---------+
| column1 | column2 |
+---------+---------+
| NULL | NULL |
| NULL | 0 |
| NULL | 1 |
| 0 | NULL |
| 0 | 0 |
| 0 | 1 |
| 1 | NULL |
| 1 | 1 |
| 1 | 1 |
| NULL | NULL |
| NULL | 0 |
| NULL | 1 |
| 0 | NULL |
| 0 | 0 |
| 0 | 1 |
| 1 | NULL |
| 1 | 1 |
| 1 | 1 |
+---------+---------+[/tt]

What do you expect the output to be? ______________________________________________________________________
TANSTAAFL!

 

[Vaastav]

+---------+---------+
| column1 | column2 |
+---------+---------+
| NULL | NULL |
| NULL | 0 |
| NULL | 1 |
| 0 | NULL |
| 0 | 0 |
| 1 | 1 |
| 1 | NULL |
| 0 | 0 |
+---------+---------+

The data in the table can either be the same i.e. 0 0 or 1 1 but not different values in each column for the same row.

This what I'm aiming for:-
0
1
0
0
1
1
0

Thanks

 

[sleipnir214]

But NULL counts as matching either 1 or 0? ______________________________________________________________________
TANSTAAFL!

 

[Vaastav]

Its okay thanks for having a look at this. I think I've sussed it.

Vaastav