>> Let's say I have 1000 records in a 'table'. I want to select rows from 6 >> to 11. How can I do this?
> SELECT * FROM tablename where column>5 AND column<12; No, no. I have no numerical fileds in the table. Your example is not good. Even if I could add the 'id' column to the table, then when I will remove some records from the middle part o the table I will have holes, and the next select will give me wrong data. Regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]