Here is the manual. I suggest you try a search for "LIMIT" in the context of a SELECT.

http://dev.mysql.com/doc/mysql/en/index.html

However what it sounds like you really ought to do is give a walk through the tutorial.

http://dev.mysql.com/doc/mysql/en/Tutorial.html

If, after exploring these two links, you still have questions feel free to post them and people will be glad to be of assistance.

RTFM,

--V


Stuart Felenstein wrote:
I'm tring to extract all records belonging to one ID
in a table. BUT! I want to do it in piece meal. Meaning a record
at a time. I am assuming I need some kind of count mechanism.


Example: I want to see the first 3 purchases this member made.
Instead of grabbing them all in one shot, I want to
break those 3 out in 3 seperate results set


Results Set1: Purchase 1
Results Set2: Purchase 2
Results Set3: Purchase 3

This is probably easy.

Thank you,
Stuart


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to