title: MySQL: How to add one day to datetime field in query
body: <p>In my table I have a field named <code>eventdate</code> in <code>datetime</code> format like <code>2010-05-11 00:00:00</code>.</p>
  
  <p>How do i make a query so that it adds <strong>one day</strong> to the <code>eventdate</code> eg if today is <code>2010-05-11</code>, i want to show in <code>where</code> clause to return all records with tomorrow's date.</p>
  
  <p><strong>Update:</strong></p>
  
  <p>I tried this:</p>
  
  <p><code>select * from fab_scheduler where custid = 1334666058 and DATE_ADD(eventdate, INTERVAL 1 DAY)
  </code></p>
  
  <p>But unfortunately it returns the same record even if i add an interval greater than 1.</p>
  
  <p><strong>Result:</strong></p>
  
  <p><code>2010-05-12 00:00:00</code></p>
  
  <p>But i only want to select records with tomorrow's date.</p>