List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:March 20 2007 5:55pm
Subject:Re: about limit
View as plain text  
How about...

SET @x=(SELECT COUNT(*) FROM ... WHERE ...) - 20;
SET @sql=CONCAT("SELECT ... FROM ... WHERE ... LIMIT 20,", @x );
PREPARE stmt FROM @sql;
EXECUTE stmt;
DROP PREPARE stmt;

PB

-----

Dan Buettner wrote:
> Another solution might be something like:
>
> SELECT * FROM tablename
> WHERE id NOT IN (SELECT id FROM tablename WHERE some criteria ORDER BY
> something LIMIT 20)
> ORDER BY something
>
> Dan
>
> On 3/20/07, Rolando Edwards <redwards@stripped> wrote:
>>
>> SELECT ... FROM ... LIMIT 20,100000000;
>>
>> 100 million is a little exaggeration
>> but you can other reasonably high numbers.
>>
>> Remember, LIMITs are zero-based not 1-based.
>>
>> ----- Original Message -----
>> From: "nikos" <nikos@stripped>
>> To: mysql@stripped
>> Sent: Tuesday, March 20, 2007 12:50:49 PM (GMT-0500) Auto-Detected
>> Subject: about limit
>>
>> Hello list.
>>
>> Does any body knows how to select not the LIMIT 20 records but the rest
>> of them?
>>
>> MySQL version is 4.1.21-standard and I cant make a VIEW.
>>
>> Thank you
>>
>> Nikos
>>
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>
>>
>>
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.15/728 - Release Date: 3/20/2007 8:07 AM
>   

Thread
about limitnikos20 Mar
  • Re: about limitKevin Hunter20 Mar
  • Re: about limitRolando Edwards20 Mar
    • Re: about limitnikos20 Mar
    • Re: about limitDan Buettner20 Mar
      • Re: about limitPeter Brawley20 Mar