I am needing to delete 500 discrete records from a table which all have unique ids but this is taking a LONG time. I'm wanting to optimize the process by doing it with a single statement. But what I'm trying says "zero rows deleted"
DELETE FROM `mytable` WHERE (`id` = '123456') OR (`id` = '456789');
Any leads? What's the most efficient way to delete a lot of data from a table?