title: How do I select between the 1st day of the current month and current day in MySQL?
body: <p>I need to select data from MySQL database between the 1st day of the current month and current day.</p>
  
  <pre><code>select*from table_name 
  where date between "1st day of current month" and "current day"
  </code></pre>
  
  <p>Can someone provide working example of this query?</p>