On Tue 2003-01-14 at 09:22:40 -0500, [EMAIL PROTECTED] wrote:
> > One solution could be something like
> >
> > SELECT id, first, last
> > FROM names
> > WHERE last > '$previouslast' AND first > 'previousfirst'
> > ORDER BY last, first
> > LIMIT 1
[...]
> I don't think it would loop for
It seems you want something like
select * from table
limit 1,1
for the first query and then...
select * from table
limit 2,1
You might also want to add "order by" as well to assure the proper order
each query.
HTH,
Ron
[EMAIL PROTECTED] wrote:
> Now Ben di
> I thought about answering your original post except that I couldn't figure
> out what you want. And after reading this, I'm even more confused. What
> does it mean for id's to be sorted by last name?
Ok let me see if I can state thre problem better (though I think that I am begining to
unders
> One solution could be something like
>
> SELECT id, first, last
> FROM names
> WHERE last > '$previouslast' AND first > 'previousfirst'
> ORDER BY last, first
> LIMIT 1
>
> That is: Take all results that "come after" the previous name, sort
> them and then take only the first.
>
> The
Hi.
On Tue 2003-01-14 at 06:02:10 +, [EMAIL PROTECTED] wrote:
> > SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
> >
> > Work? Limits to one result, start at second offset. (I may have the 2,1 in
> > the wrong order though)
>
> Ok my gut would say that this would not give the result
> Ok my gut would say that this would not give the result I want
> unless the id's are sorted by last name, and given inserts and
> such I can see that would not be the case. But I sense the
> glimmer of an approach in this query...
You're right, I don't know why I thought you wanted to sort by
At 6:02 + 1/14/03, [EMAIL PROTECTED] wrote:
> SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
Work? Limits to one result, start at second offset. (I may have the 2,1 in
the wrong order though)
Ok my gut would say that this would not give the result I want
unless the id's are s
> SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
>
> Work? Limits to one result, start at second offset. (I may have the 2,1 in
> the wrong order though)
Ok my gut would say that this would not give the result I want unless the id's are
sorted by last name, and given inserts and such I
0 PM
> To: [EMAIL PROTECTED]
> Subject: select the next name
>
>
> To begin with I am only about 3/4 of the pay through paul d's
> great book so bear with me. Say I have a table (names) with
> columns (id, first, last) and I want the next name when ordered
> by last, firs
To begin with I am only about 3/4 of the pay through paul d's great book so bear with
me. Say I have a table (names) with columns (id, first, last) and I want the next
name when ordered by last, first in the table, say given a particular id. So how
would I frame the query. Something like
sel
10 matches
Mail list logo
