title: How to get today's / yesterday's data from MySQL database?
body: <p>I would like to retrive a TODAY'S data from the database, but I don't know how to do it. I would actually want to get the data from NOT the past 24 hours, I just want today's data (so based on the actual server time).</p>
  
  <p>I would also like to get data which was yesterday. Can anyone help me how to do it?</p>
  
  <p>Sample code:</p>
  
  <pre><code>"SELECT id FROM folk WHERE time = ???"
  </code></pre>
  
  <p>Thank you in advance!</p>