title: mysql MULTI DELETE error
body: <p>I have mysql query</p>
  
  <pre><code>DELETE data 
      FROM table 
          WHERE DATE_SUB(NOW(), INTERVAL 1 DAY) 
              AND status &lt;&gt; 0;
  </code></pre>
  
  <p>And i get this error:</p>
  
  <blockquote>
    <p>ERROR 1109 (42S02) at line 2: Unknown table 'date' in MULTI DELETE</p>
  </blockquote>
  
  <p>How fix this?</p>