title: SQL count how many times a value appears in multiple columns?
body: <p>I have two columns in a mysql database that i would like to count how many times a single name appears in both columns. The COUNT function by itself doesn't work for me as it only counts the total in one column. </p>
  
  <p>MySql Columns:</p>
  
  <pre><code>+-----------------+--------------+
  | Member1         | Member2      |
  +-----------------+--------------+
  | John            | Bill         | 
  | Bill            | John         |
  | Joe             | John         |
  | Bill            | Joe          |
  | John            | Steve        |
  +-----------------+--------------+
  </code></pre>
  
  <p>Desired output:</p>
  
  <pre><code>+-----------------+--------------+
  | Member          |     Total    |
  +-----------------+--------------+
  | John            | 4            | 
  | Bill            | 3            |
  | Joe             | 2            |
  | Steve           | 1            |
  +-----------------+--------------+
  </code></pre>
  
  <p>Any ideas?? Thanks!</p>