title: Find all mysql rows from last month with unixtimestamp
body: <p>I am trying to find a better way of selecting all rows created in the previous month. Currently I am just going back x number of days, but I want it to run on the 1st of every month, and don't want to have to keep adjusting it.</p>
  
  <p>Essentially, I just want it to select from the "date" field where the month is the previous month.</p>
  
  <p>Here is my current sql:</p>
  
  <pre><code>SELECT a.*
  FROM (SELECT a.article_id, a.date, a.tagline_image, a.article_top_image_filename, a.title, a.tagline, a.views, c.category_id
      FROM 
          articles a
      LEFT JOIN 
          `article_category_reference` c ON a.article_id = c.article_id
      WHERE 
          a.date &gt;= UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 33 DAY)) AND c.category_id NOT IN (63) AND a.active = 1 group by `a`.`article_id`
      ORDER BY 
          a.views DESC
      LIMIT 30
       ) a
  ORDER BY views ASC
  </code></pre>