SELECT * FROM tablename LIMIT 5, 6 "Me fail English? That's unpossible" ###___Archon___###
----- Original Message ----- From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Maciej Bobrowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 4:47 PM Subject: Re: specific records SELECT * FROM tablename where column>5 AND column<12; Best regards Nils Valentin Tokyo/Japan 2003年 7月 2日 水曜日 18:26、Maciej Bobrowski さんは書きました: > Hi, > > Let's say I have 1000 records in a 'table'. I want to select rows from 6 > to 11. How can I do this? > > > Regards, > Maciej Bobrowski -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]