title: Select all rows from start of the year, month, week and day in MySQL?
body: <p>I am looking for a way to be able to select all the rows from the start of a year, month, week and day on the current day from a MySQL database..</p>
  
  <p>For example, let's suppose that today's date is 12th March 2017.</p>
  
  <ul>
  <li>The year query would select all posts from the start of 2017</li>
  <li>The month query would select all posts from the start of March 2017</li>
  <li>The week query would select all posts from the start of the weeks that date is on</li>
  <li>The day query would select all posts from the start of 12th March 2017</li>
  </ul>
  
  <p>In  the database I have got a 'date added' column which stores dates in the format of '2017-03-12'.</p>
  
  <p>Thanks in advance</p>