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.
Richard mailto:[EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php