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]