O.K. I found the way:
select * from tablename limit 5,6; it will select 6 records counting from 6. >> Let's say I have 1000 records in a 'table'. I want to select rows from6 >> to 11. How can I do this? > SELECT * FROM tablename where column>5 AND column<12; Best regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]