title: How can i make condition when date in db less than date now 7 days in event mysql?
body: <p>I want make Event in my mysql but the problem is in where condition , I want make update my column if date today is greater than date in databse more or equal 7 days...
  this is how the date looks like in mysql  <strong>2017-03-02 11:22:43</strong></p>
  
  <pre><code>update mytable
  set status=0
  where date(insert_at) &lt; date('-7 day')
  </code></pre>
  
  <p>Any help i will be gratfull</p>