title: Select rows from table in Php/Mysql based on time or two dates?
body: <p>hi i have players table in mysql .</p>
  
  <p>i need to select inactive players who have not played a match for 6 months in the league .</p>
  
  <p>for example -></p>
  
  <pre><code>select * from players where player (matchplayed == true &amp;&amp; (in last 6 months condition));
  </code></pre>
  
  <p>i am newbie in mysql</p>
  
  <p>so will like some help how to deal with time .</p>