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
>
>
