title: Concisely finding rows from less than 6 months ago in MySQL
body: <p>I'm trying to find entries in my table from between 6 months ago and today. Here's the query that I'm currently running: </p>
  
  <pre><code>WHERE (DATE(l.date_fin) BETWEEN DATE(DATE_ADD(NOW(), INTERVAL -6 MONTH)) AND CURDATE())
  </code></pre>
  
  <p>However, it doesn't look right to me: it feels like there's a more concise and/or faster way to get the same results as this query. Is there any such way?</p>