How to select odd and even numbers in mysql

[Gunabalan123]

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.

[Luuk]

you posted this in 'Questions', should it not be in 'Articles'

[Bala Kumaran]

This may help you try this

http://social.msdn.microsoft.com/For...um=transactsql