在十进制列中查找MySQL中最接近的匹配项

SELECT *
FROM table_name
WHERE column_name = (
    SELECT column_name
    FROM table_name
    ORDER BY ABS(column_name - 123.45)
    LIMIT 1
);

SELECT *
FROM table_name
WHERE column_name IN (
    SELECT column_name
    FROM table_name
    WHERE column_name = (
        SELECT column_name
        FROM table_name
        ORDER BY ABS(column_name - 123.45)
        LIMIT 1
    )
    UNION
    SELECT column_name
    FROM table_name
    WHERE column_name = (
        SELECT column_name
        FROM table_name
        ORDER BY ABS(column_name - 123.45)
        LIMIT 1, 1
    )
);