in reply to mySQL query

SELECT * FROM myTable WHERE (id > 20) AND (id < 50);

[download]
would work rather nicely, but does assume that you're using an autoincrementing value in your tables. Can't think of a way to do it without autoincrements, though

Replies are listed 'Best First'.
Re: mySQL query
by Abigail-II (Bishop) on Jul 07, 2003 at 08:06 UTC
    That would return at most 30 rows, not necessarely 30 rows. If rows get deleted over time, the autoincremented values stay the same; they aren't recalculated, or reused.

    Abigail

[reply]

In Section Seekers of Perl Wisdom