[snip] Jay Blanchard wrote: > [snip] > 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 2, > 4, > 6, 8, ... > > Can this be done with LIMIT? > [/snip] > > Not LIMIT, but you can use MOD, especially with an auto-increment field > (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... so 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) [/snip] The problem is that this only returns ONE record, the OP wanted every other record -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
