title: Mysql: Searching for data by month only yields one result not all of them
body: <p>I have an Orders table with the Date_ordered column. </p>
  
  <p>I am trying to select the average price of all of the items ordered that were purchased in the month of December.</p>
  
  <p>I used </p>
  
  <pre><code>select *, avg(price) from orders where monthname(date_ordered) = "december"
  </code></pre>
  
  <p>However it is only coming up with one result, when my table has 4 instances of the date being xxxx-12-xx</p>
  
  <p>Note: There are multiple years included in the data but they are irrelevant to the query I need</p>