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/Forums/sqlserver/en-US/036f9621-2281-49e4-ad79-a4aabafeb60a/how-to-show-only-even-or-odd-rows-in-sql-server-2008-?forum=transactsql