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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
