[Resolved] Help with SELECT

[mrJazz]

Hi Folks,

Using the following example table...

+---+---------------------------+----------------------------+
| id | email1 | email2 |
+---+---------------------------+----------------------------+
| 1 | [e-mail] | [e-mail] |
+---+---------------------------+----------------------------+
| 2 | [e-mail] | [e-mail] |
+---+---------------------------+----------------------------+

I want to get a list of all the email addresses in one query, so it will produce something like...

+---------------------------+
| email |
+---------------------------+
| [e-mail] |
| [e-mail] |
| [e-mail] |
| [e-mail] |
+---------------------------+
4 rows in set (0.00 sec)

Any ideas? Must be one query only...

[rachel2004]

http://dev.mysql.com/doc/mysql/en/UNION.html

Use UNION

[mrJazz]

Thanks rachel2004 that's great but unfortunatly I am only using MySQL 3xxx Doh....