If you have to select the id: DELETE FROM table WHERE id IN (SELECT id FROM somewhere_else) If you already know them (and they are not in the thousands): DELETE FROM table WHERE id IN (?,?,?,?,?,?,?,?)