Hi guys,

sorry for posting a non-Java question to this list, normally I'm only lurking and trying to help best I can, but here's something that's a bit over my head:

does MySQL provide a means to add an automatic counter to a select statement, and return results using this counter in a BETWEEN conditional?

Background: I have a table countaing about 1,000 numbers to be ordered ASC, and instead of printing a giant HTML table I'd like to select the first 25 entries (easy using the LIMIT statement) and, say 20 around the users current position.

Thanks in advance for your help,

Uwe