Date: 2009-09-30 07:53 pm (UTC)
From: (Anonymous)
I don't think you can do this in a single select (that is, without using subselects) .

If you are willing to load the next and previous objects in dedicated queries, you can use something like:

select *
from table
where id > ?
order by id
limit 1
This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

Profile

elfs: (Default)
Elf Sternberg

June 2025

S M T W T F S
1234567
891011121314
15161718192021
22232425262728
2930     

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 6th, 2025 12:06 am
Powered by Dreamwidth Studios