title: How to select row of last week, last month and last year form mysql database table
body: <p>What I need is exact: Query for get records of between from current date to previous week OR previous month OR previous year.  </p>
  
  <pre><code>SELECT * FROM `job` as j WHERE j.`created_at` &lt;= LAST_DAY(DATE_SUB(NOW(), INTERVAL 1 MONTH))
  </code></pre>
  
  <p>Ex. Currently running 08(august) month then i want to get records inserted between 07(july) to 08(august) months </p>