title: Select min, max, avg, WHERE
body: <p>I'm using MySQL.</p>
  
  <p>I'm trying to select the minumum, maximum and average length of a field but I'm not sure how. Something like this:</p>
  
  <pre><code>SELECT 
    min as min,
    max as max,
    avg as avg
  FROM COLUMNS
  WHERE COLUMN_NAME like '%password%'
  </code></pre>
  
  <p>Any ideas?</p>