如何从mysql [duplicate]返回最近的值

Question

This question already has an answer here:

• Select closest numerical value with MySQL query 3 answers

If I had a table something like

ID     VALUE
1      1000
2      1500
3      2000

and I were to select value='1999' it would return the 3rd row. If I were to select 1200 instead, it would return the 1st row. How do I do that in php?

</div>

Answer 1

What a nice question :)

SELECT VALUE FROM mytable ORDER BY ABS(VALUE-1999) LIMIT 1

Of course that 1999 will be a variable in real.

Fiddle