title: MySQL DATE_ADD() not working
body: <p>In my database I have a table containing some business offers. One of the columns is <code>expire</code>, which contains the date a certain offer expires.</p>
  
  <p>I want to select all offers which expire in 10 days. Here is my code:</p>
  
  <pre><code>SELECT * FROM offers WHERE TIME_ADD(NOW(), INTERVAL 10 DAYS) = expire;
  </code></pre>
  
  <p>I want to select all columns from offers, where the expiry date is equal date now plus 10 days (so they expire in 10 days). MySQL doesn't let me do that, it marks "=expire" as an error </p>
  
  <blockquote>
    <p>Syntax error unexpected 'expire' (expire).</p>
  </blockquote>
  
  <p>Why is that? ( I'm working on MySQL workbench btw)</p>