title: Select distinct from multiple fields using sql
body: <p>I have 5 columns corresponding to answers in a trivia game database - right, wrong1, wrong2, wrong3, wrong4</p>
  
  <p>I want to return all possible answers without duplicates.  I was hoping to accomplish this without using a temp table.  Is it possible to use something similar to this?:</p>
  
  <pre><code>select c1, c2, count(*)
  from t
  group by c1, c2
  </code></pre>
  
  <p>But this returns 3 columns.  I would like one column of distinct answers.</p>
  
  <p>Thanks for your time</p>