Re: Kind of BETWEEN

[Nick Roper]

Thomas,

Assuming you are using version 4.0 +, then try something like:


(SELECT num FROM numbers
WHERE num < 1100
ORDER BY num DESC
LIMIT 2)
UNION
(SELECT num FROM numbers
WHERE num > 1100
ORDER BY num ASC
LIMIT 2)
ORDER BY num;




--
Nick Roper