Re: Want to exclude first 10 records from table
| From: | arvind | Date: | Wed, 16 Oct 2002 07:26:08 +0000 |
| Subject: | Re: Want to exclude first 10 records from table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120125@lists.php.net to get a copy of this message | ||
Try this,
To retrieve all rows from a certain offset upto the end of the result set,
you can use -1 for the second parameter:
mysql> SELECT * FROM table LIMIT 95,-1; # Retrieve rows 96-last.
"Manisha" <manisha@aurica.com> wrote in message
news:4.3.2.7.2.20021016144008.00a999c0@pop.aurica.com...
> I am having forum table. First 10 records are treated as Current postings
> and rest are treated as Archive.
>
> I know how to take first 10
>
> select * from forum order by postdate desc LIMIT 10
>
> But I do not know how to take postings excluding above 10. I do not want
to
> make use of loop rather I want to do this in one single query as I need to
> pass this to some further include files.
>
> Thanks in advance
> Manisha
>