title: Getting the "mean value" for a column in a database table
body: <p>I have a database row of entries, with a common column that contains a string value, "L" "LV" "LRW" and "AD". Asssuming that there are a numerous number of these fields, with multiple values of this nature. Is there a way inside a SQL query to return the most occurring value of this column (essentially, the mean average), over returning all the column entries, or should I delegate this higher up in the development chain?</p>
  
  <p>Edit: Per requests, here's an example setup of what the table actually looks like:</p>
  
  <pre><code>+------------+---------+
  |    Ent1    |  value  |
  +------------+---------+
  | 1          | L       |
  | 2          | L       |
  | 3          | LV      |
  | 4          | AD      |
  | 5          | AD      |
  | 6          | L       |
  | 7          | LRW     |
  | 8          | L       |
  +------------+---------+
  </code></pre>