Re: MySQL LIMIT 4,6 returns 5 rows!
| From: | Mark | Date: | Tue, 16 Oct 2001 00:26:45 +0000 |
| Subject: | Re: MySQL LIMIT 4,6 returns 5 rows! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-71282@lists.php.net to get a copy of this message | ||
On Wed, 17 Oct 2001 02:24:04 +0200, Ben Edwards wrote:
>strange one here, could someone explain why
> select * from subverts where status = 'L' order by date_added
>desc LIMIT
>4,6
>Reruns 5 rows?
because there were only nine?