In the last episode (Nov 12), Waynn Lue said:
> 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.
How about joining them with a UNION? Two queries for the round-trip
cost of one!
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
