To select even or odd IDs from a MySQL table, you would use the 'MOD', this easy way to select the Odd and Even numbers/.
Odd number select...
select column_name from table_name where mod(column_name ,2)=1;
Even number select..
select column_name from table_name where mod(column_name ,2)=0;
if u need odd or even number put 1 or 0.