Please help with deleting "every other row" in mysql table

[eapro]

What I'm trying to do is simple; I need to delete every other row in a mysql table.
skip row, delete, skip row, delete, skip row, delete ...

For example this table:

id | name
---------------
1 | John
2 | Bob
3 | Mary
4 | Alex
5 | Tom
6 | Pat


After delete, becomes this:

id | name
---------------
1 | John
3 | Mary
5 | Tom


Any ideas?

[Fumigator]

Assuming your "id" column is a continuous sequence of numbers, check the modulus of the id divided by 2 and delete when it's 0.


DELETE FROM table1
WHERE ID % 2 = 0

[eapro]

That worked perfectly, thanks! :)