Jay Blanchard wrote:
> Is it possible to select only every second record from a record set?
> I should select the record-number 1, 3, 5, 7, 9, ... or record-number
> 6, 8, ...
> Can this be done with LIMIT?
> Not LIMIT, but you can use MOD, especially with an auto-increment
> (id in this case is the auto-increment field)
> select * from table where mod(id, 2) <> '0' returns odd rows
> select * from table where mod(id, 2) <> '1' returns even rows
You have to do it with LIMIT
beacuse id may not help you...
select * from table where <condition> [group by <field>]
[order by <field> [desc]] LIMIT 2,1
this select just second resultrow from any kind of resultset made using
every thing you like in where/order by/groub by and not being limited by
using IDs (auto_increment)
The problem is that this only returns ONE record, the OP wanted every