At 04:03 PM 23-06-2000 +0800, Lincoln Yeoh wrote:
>At 10:55 AM 23-06-2000 +0400, you wrote:
>>You could probably do this:
>>
>>select * from yourtable where <key> > <known_row_key>
>> order by <key> limit 1;
>>
>>- isn't it?
>
>Thanks. Looks like that would work. Dunno why previously I thought that
>wouldn't have worked- fuzzyminded today I guess.
>(if list was ordered by date and messageid)
>select * from table where criteria=xxxxx and messageid > currentmessageid
> order by date, messageid limit 1;
Ack! I am fuzzyminded today. That won't work.
I think I'll go take a break now...
Cheerio!
Link.