title: MySQL Between start of previous month and today
body: <p>Current I am grabbing a list of users where their account was created between current date and 1 month ago. However I want to adjust this so it pulls all who registered from the start of last month and current date.</p>
  
  <pre><code>WHERE FROM_UNIXTIME(timecreated) BETWEEN CURDATE()-INTERVAL 1 MONTH AND CURDATE() 
  </code></pre>
  
  <p>How can thos be achieved?</p>