Hi php-db,

I have a table with approx. 250,000 rows in it. The primary key is an
ID field. All I am wondering is - is there any way at all from MySQL
to directly select every 50th row in this table?

I.e. row 1, 50, 100, 150, etc and return the ID of each row, ideally
with some kind of limit. Even if it was only possible to select the
IDs of two rows, i.e. row 1 and row 50, that would be good too.

It's almost like I need a "step" function, like in a FOR NEXT
statement, only SQL-side.

Best regards,
 Richard                          mailto:[EMAIL PROTECTED]

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to