Re: Select every other record

[Ramalingam Chelliah]

Hi ,

You can use MOD function on integer field ...

If you have set up ID as integer field and if ID is your primary key ...
say in table table1

Then do like this to get ODD records....

mysql> SELECT * from table1
WHERE MOD(ID,2)=1;

for even MOD(ID,2) should be 0;

Hope this helps...

Regards,
Ram.


We Learn the Most When we have to Invent