ORDER BY (ABS(volume - %введёный объём%)) ASCORDER BY (ABS(volume - %введёный объём%) + ABS(height - %введёная высота%)) ASC`LIMIT 3SELECT * FROM articles ORDER BY (ABS(volume - 5)) ASC LIMIT 3SELECT * FROM articles ORDER BY (ABS(volume - 5) + ABS(height - 8)) ASC LIMIT 3
SELECT *
FROM `table`
WHERE `field` = :value
UNION (
SELECT *
FROM `table`
WHERE `field` > :value
ORDER BY `field` DESC
LIMIT 1)
UNION (
SELECT *
FROM `table`
WHERE `field` < :value
ORDER BY `field`
LIMIT 1)
Простой
Средний
Простой