MySQL SELECT Statment to return 2 coloumns into 1

Question

Hi,

I have a table with the following columns

 id, teamA_id, teamB_id

Will it be possible to do a MYSQL SELECT statement that gives both teamA_id and teamB_id in the same column?

EDIT

Consider this example

From

 id, teamA_id, teamB_id
 1, 21, 45
 2, 34, 67

I need

Teams
21
45
34
67

Answer 1

SELECT teamA_id as 'Teams'
FROM Teams

UNION

SELECT teamB_id as 'Teams'
FROM Teams