In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> 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.
For a simplistic solution(?) assuming that your ID is integer and there
are no gaps in the sequence, you could do a single select where ID mod 50
Quod subigo farinam
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
Q: What is the most annoying thing on usenet?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php