[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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
