Maciej Bobrowski wrote:
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
Maybe:
SELECT * FROM tablename LIMIT 5,5;
See:
http://www.mysql.com/doc/en/SELECT.html
for details
Regards,
Joseph Bueno
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
