previous and next query

[Tanner Postert]

so i have a record set:

id user text
1  2  ...
2  6  ...
3  2  ...
4  4  ...
5  2  ...
6  8  ...
7  1  ...
8  8  ...
9  2  ...


so lets say I am looking at record 3. i need to know the previous record in
the table that has that user, as well as the next record in the table that
has that user.

right now i am using 2 queries.

select text from table where user = 2 and id < 3 order by id ASC limit 1;
select text from table where user = 2 and id > 3 order by id ASC limit 1;

is it possible to do this using 1 query?