select every 100th db entry ??

Hi,

How can I make a query from my db in order to select every 100th entry
eg: 100,200,300,400.....n

I know how to do it when using php to access the db, but would like the query to handle it

THANKS !!

You could write a cursor that loops through the table and increments a counter for each loop. Add some code to the cursor inserts every nth row into a temporary table, and then select all the rows from the temp table when the cursors is done. From a performance perspective, you might be better off doing the processing outside of the database, but I can't say for sure.

I also thought of doing it that way, I was just wondering if a single query eg: "SELECT * from DB WHERE ......" would be able to handle this.

Thanks anyway

Do you have an auto incrementing ID field? If so you could do something to the effect of:

Thanks, but I decided to rather do as lucasalexander suggested. I do have a auto increment, and gues it will work your way but rows gets deleted sometimes and that makes the auto-increment not so accurate.

I know there are ways to by-pass this, but seems like to much admin.

Thanks anayway !