Well I try to avoid the manual , but refer to some books that I've collected. Essentially the same, but more palatable for my tastes. Not that I wouldnl't check the manual.
What I needed was "order by Desc limit (x, x) . In my case 3 queries, with (0,1)(1,1)(2,1) . The first 3 records , 1 at a time. Stuart --- "V. M. Brasseur" <[EMAIL PROTECTED]> wrote: > 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]
