title: how to combine two columns in mysql and make it as one column?
body: <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>