Whoops, just realized I made a mistake in the examples. What I'm really looking for is these two queries:
SELECT * FROM Users WHERE UserId > *userid*; SELECT * FROM Users WHERE UserId < *userid*; Waynn On Wed, Nov 12, 2008 at 12:14 AM, Waynn Lue <[EMAIL PROTECTED]> wrote: > I'm trying to find the first row before and the first row after a specific > row. Essentially I want to do these two queries, and get each row. > > SELECT * FROM Users WHERE UserId = <userId> ORDER BY UserId DESC LIMIT 1; > SELECT * FROM Users WHERE UserId = <userId> ORDER BY UserId LIMIT 1; > > Is there any way to combine this into one query? OFFSET doesn't allow a > negative number, which is essentially what I want. > > Thanks, > Waynn >
