Re: Limiting results to X number of rows
| From: | Rasmus Lerdorf | Date: | Sun, 02 Jul 2000 17:51:22 +0000 |
| Subject: | Re: Limiting results to X number of rows | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-4379@lists.php.net to get a copy of this message | ||
> Does anyone know of a way to limit the mysql return results to X number of
> rows? In Oracle, I use rowcount < 10, but I can't use this in Mysql.
>
> The only way I can think to do this is to do a select then subtract the
> number I want from the total. Then in the select statement I need it in,
> select * from table where id > previous_select.
>
> Any tips?
select * from table limit 10
-Rasmus