php - 如何将mysql中的两列合并为一列？

Question

+-----+---------------+---------------+
| id  |    team_A     |    team_B     |
+-----+---------------+---------------+
|  1  |   Barcelona   |  Real Madrid  |
+-----+---------------+---------------+
|  2  |     Milan     |     Inter     |
+-----+---------------+---------------+

select * from table and combine as team_c

结果应该是一列..

team_c as

barcelona
milam
real
inter

team_c 中的所有行都应该不同..因为我需要在自动完成下拉列表中显示两个？

Answer 1

试试这个查询:

select a.team_a as team_c from table a Union select b.team_b from table b