title: Delete many rows from a table using id in Mysql
body: <p>I am a Linux admin with only basic knowledge in Mysql Queries </p>
  
  <p>I want to delete many table entries which are ip address  from my table using <strong>id</strong>,</p>
  
  <p>currently i am using </p>
  
  <pre><code>DELETE from tablename where id=1;
  DELETE from tablename where id=2;
  </code></pre>
  
  <p>but i have to delete 254 entries,so this method is going to take hours,how can i tell mysql to delete rows that i specify,coz i want to skip deleting some entries out of this 254.</p>
  
  <p>Deleting whole table and importing needed entries is not an option.</p>