List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 28 2000 10:24pm
Subject:Re: Select next 10
View as plain text  
At 2:07 PM -0800 11/28/00, Steve Lewis wrote:
>  > >Just with LIMIT
>>  >SELECT * FROM foo LIMIT 10
>
>so I have been wondering... how do I select only the 11th through the 20th
>matching records (for example)?

It wouldn't be a bad idea to spend some time reading the manual.
The section on SELECT answers your questions:

http://www.mysql.com/documentation/mysql/commented/manual.php?section=SELECT

-- 
Paul DuBois, paul@stripped
Thread
Select top 10Rodrigo PĂ©rez28 Nov
  • Re: Select top 10personal)28 Nov
  • Re: Select top 10Colin Faber28 Nov
Re: Select top 10Bob Hall28 Nov
  • Re: Select top 10Angel Behar Rodriguez28 Nov
    • Copying data between identical tables in different DBFSMatthew Clark28 Nov
    • RE: Select top 10Carsten H. Pedersen28 Nov
  • Re: Select next 10Steve Lewis28 Nov
    • Re: Select next 10Stephen Johnson28 Nov
      • Re: Select next 10Steve Lewis29 Nov
    • Re: Select next 10Paul DuBois28 Nov