title: how to construct a sql condition for not "created" two thursdays ago
body: <p>I have this condition in my sql for MySQL:</p>
  
  <pre><code>Created &gt;= CONCAT( DATE_SUB(CURDATE(), INTERVAL WEEKDAY(DATE_SUB(CURDATE(), INTERVAL 4 DAY)) DAY), ' 00:00:00')
  </code></pre>
  
  <p>It is from at test to see if a user have participated since last thursday. Now the higher powers have decided, that it should change from weekly to every other week. That means the condition should change to check that Created is after two thursdays ago.</p>
  
  <p>Any suggestions?</p>