see if the limit keyword will do what you want.
select * from table limit 0, 2000
> Hi all,
>
> is it possible to limit a result so that only the first record in a query
> can be returned for a specific user?
>
> I want to do this so that someone who does not have intimate knowledge of
> a large (>100000 records) table cannot issue commands to grab *all* of the
> data.
>
> Thanks ahead of time for any info!
>
> --Raj
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
