recordset paging in MySQL

Hi.

I was wondering if I can page a recordset from a MySQL-db. I tried the way I learned to use with Access (i.e. with rst.PageSize, rst.RecordCount and rst.PageCount), but it didn't do me no good (b-t-w, cursortype was 'adOpenStatic').

Does MySQL support paging (or is this db-independent) and if so, can anyone provide me with a way to do so (perhaps s.th. along the lines of the 'LIMIT'-clause in the SQL statement?).

Thanks!