Select Nth row

[BFTrick]

Hi there,

I am looking for some help selecting the Nth row for a particular query.

I want to select the Nth row for a query that looks similar to this:

SELECT * FROM Comic WHERE Visible = 1 ORDER BY DatePublished

You would think there would be an easy way to select the nth row, I did some Googling and got all kinds of answers.

[Nedals]

Read up on 'LIMIT'
LIMIT m,n -> return 'n' rows beginning at row 'm'

[BFTrick]

Thanks a bunch. That did it.

The embarassing thing is that I have used LIMIT before.