how to combine two columns in mysql and make it as one column?
<pre><code>+-----+---------------+---------------+
| id  |    team_A     |    team_B     |
+-----+---------------+---------------+
|  1  |   Barcelona   |  Real Madrid  |
+-----+---------------+---------------+
|  2  |     Milan     |     Inter     |
+-----+---------------+---------------+

select * from table and combine as team_c
</code></pre>

<p>and result should be like one column..</p>

<pre><code>team_c as

barcelona
milam
real
inter
</code></pre>

<p>all rows should in <strong>team_c</strong> should be different..
because i need two show in an autocomplete dropdown?</p>