title: Get the most common values for all columns
body: <p>I want to get the most common values for all columns in a mySQL table.</p>
  
  <pre><code>[id]  [UserID]            [UserID2]
  1     johnnietheblack     marywhite
  2     johnnietheblack     marywhite
  3     dannyrottenegg      dannyrottenegg     
  4     marywhite           marywhite
  5     marywhite           johnnietheblack     
  6     johnnietheblack     marywhite
  </code></pre>
  
  <p>Here's the output I want:</p>
  
  <pre><code>[id]  [UserID]            [Count]
      1     johnnietheblack     4
      2     dannyrottenegg      2
      3     marywhite           6
  </code></pre>
  
  <p>I can use the following to get the common values for one columns. But how can I get the common values for <strong>all columns</strong>?</p>
  
  <pre><code>SELECT COUNT(*) AS `Rows`, UserID
  FROM table-name
  GROUP BY UserID
  ORDER BY `Rows` DESC
  </code></pre>