How to organize such a double request?

Question

MySQL

I need to make a double selection - first select all the values ​​from the table where side="bright", and then find the closest values ​​to my given value in the results (for example, 100). I understand that in the second one there should be something like ABS(100 - results) and you need to use a double query, but I don’t understand how to implement it at all.

Answer 1

Something like?

SELECT *, ABS(100 - results) AS diff
FROM t
WHERE side = 'bright'
ORDER BY diff ASC
LIMIT 5

Answer 2

I think you need something like

SELECT * 
  FROM (
    SELECT TOP 10 ABS(100 - result) as diff
    FROM t
    WHERE side = 'bright') b
  WHERE diff < 20

Where 100 is your target value and 20 is the error, i.e. "nearest values" that differ by no more than 20