select an entry with specified id, and also one entry before and after
I have a table which looks like this one:

    | id | fk_book | name |
    -----------------------
    | 1  | 2       | test1|
    | 3  | 2       | test3|
    | 6  | 3       | notes|
    | 7  | 2       | test2|

No I want to get the entry with the id 3. select * from test where id=3;

but is there also a way to get the item with id 1 and 7?

thanks

 
select an entry with specified id, and also one entry before and after
===

I have a table which looks like this one:

    | id | fk_book | name |
    -----------------------
    | 1  | 2       | test1|
    | 3  | 2       | test3|
    | 6  | 3       | notes|
    | 7  | 2       | test2|

No I want to get the entry with the id 3. select * from test where id=3;

but is there also a way to get the item with id 1 and 7?

thanks

 