title: How to get 1st week record from MYSQL for given month
body: <p>I have a table called users with id, name and created date. Now i want to show user registered on 1st, 2nd, 3rd and 4th week of January separably. Like this i want to show for all month.  How can i achieve this?</p>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>I tried </p>
  
  <pre><code>SELECT id, date, WEEK(date) weekno FROM user WHERE MONTH(date) in (4,5)
  </code></pre>