title: MySQL: Returning records from the current month and previous 3 months
body: <p>I'm using PHP/MySQL booking system and i'm using a Google Line Chart to try and display the gross sales from the current month, and also the previous 3 months.</p>
  
  <p>Each booking has a date in the standard phpmyadmin "date" format, so yyyy:mm:dd.</p>
  
  <p>So, im looking to get 4 results from 4 queries, each query filtering out a certain month and grabbing the sum of each booking from that month.</p>
  
  <p>My question is, how can i distinguish between the months in the query? How would i structure the query? </p>