title: Calculate average of column from MYSQL query
body: <p>I've got a table that I am trying to calculate the average of the values in a column.  Here is my lookup:</p>
  
  <pre><code>SELECT SUM(P1_Score) AS value_sum FROM tblMatches Where P1_ID LIKE $playerID
  </code></pre>
  
  <p>Any idea how I can determine the average (sum of values / total rows)?</p>