I have a database, and I want to find out the previous and next record ordered by ID, using a single query. I tried to do a union but that does not work. 🙁
SELECT * FROM table WHERE `id` > 1556 LIMIT 1 UNION SELECT * FROM table WHERE `id` <1556 ORDER BY `product_id` LIMIT 1
Thanks a lot.