From: Peter Brawley Date: March 20 2007 5:55pm Subject: Re: about limit List-Archive: http://lists.mysql.com/mysql/205702 Message-Id: <4600201F.2000604@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------000001080409080109070207" --------------000001080409080109070207 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 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" >> 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=redwards@stripped >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=drbuettner@stripped >> >> > > ------------------------------------------------------------------------ > > 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 > --------------000001080409080109070207--