List:General Discussion« Previous MessageNext Message »
From:Antony Dovgal Date:October 16 2003 5:55pm
Subject:Re: LIMITS
View as plain text  
On Thu, 16 Oct 2003 11:49:29 -0400
"Cummings, Shawn (GNAPs)" <shawn@stripped> wrote:

> when I do a query is there a way to IGNORE the first X number of returned 
> records???
> 
> For instance I want to see 15 records after the first 50.

yes, use LIMIT clause:

SELECT * FROM tablename LIMIT 50,15;

but first read about it here:
http://www.mysql.com/doc/en/SELECT.html

---
WBR,
Antony Dovgal aka tony2001
tony2001@stripped
Thread
LIMITSGNAPs)16 Oct
  • Re: LIMITSAntony Dovgal16 Oct
  • RE: LIMITSAlexis16 Oct
  • Re: LIMITSDirector General: NEFACOMP16 Oct