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]

Reply via email to