title: Delete mysql row where date equals expiry date
body: <p>What's the best way to run a mysql query to delete a row if it equals the date in the expire column?</p>
  
  <p>This is my current code:</p>
  
  <pre><code>$sql = "DELETE * FROM table WHERE DATE(expire) = CURDATE()";
  
  $q   = $conn-&gt;prepare($sql) or die("failed!");
  // Bind the params to the placeholders
  $q-&gt;execute();
  </code></pre>