in reply to Re^3: Calculating previous/next from database
in thread Calculating previous/next from database

You can do it in a little more convoluted way not using UNION at all:

SELECT * 
FROM table 
WHERE id=(SELECT id FROM table WHERE id>? ORDER BY id ASC LIMIT 1) 
  OR id=(SELECT id FROM table WHERE id<? ORDER BY id DESC LIMIT 1)

[download]

Careful with that hash Eugene.

In Section Seekers of Perl Wisdom