how to delete the odd ids please???

hello, i have database, in it lets say 50k row, i need to delete the rows with the odd ids... like "Delete From Table Where id (is odd)".
so how can i do that ? what is the mysql command for that please?
thanks

 

You can use the MOD() function or operator:

DELETE FROM table WHERE id%2;

Code (markup):

 

thanks a lot

 

wouldn't have have to use:
delete * from table where id%2=1

?

 

Not in this case since it could only return a remainder of 1 (which also means true) or 0 (which also means false) If he wanted even numbers instead he'd have to use id%2=0 so it would return true for odd numbers

 

Are you trying to delete the alternate rows (oddly numbered rows) or the rows where the field id is odd. Both case the query is different
example
rownum id
1 5
2 7
3 8