Kód: Vybrať všetko

SELECT uzivatel
FROM tabulka
WHERE MIN(ABS(100-cislo));

Kód: Vybrať všetko

SELECT user FROM ".TBL_SCORE." WHERE MIN(ABS(100-percent));

Kód: Vybrať všetko

function vrat_cislo_blizsie_k_100(){
    $t="nazov tabulky";
    $n="nazov 2 stlpca";
    
    $sql=mysql_query("SELECT * FROM $t WHERE $n < 100 order by id DESC LIMIT 0, 1");
    $sql=mysql_fetch_assoc($sql);
    $sql1=mysql_query("SELECT * FROM $t WHERE $n > 100 order by id ASC LIMIT 0, 1");
    $sql1=mysql_fetch_assoc($sql1);
    
    $s=100-$sql[$n];
    $s1=$sql1[$n]-100;
    
    if($s>$s1) return $sql1;
    else return $sql;
}

Kód: Vybrať všetko

SELECT * FROM `tabulka` WHERE `percento` <= 100 ORDER BY `percento` DESC LIMIT 1

Kód: Vybrať všetko

SELECT user 
FROM tabulka 
WHERE ABS(100-cislo) = (SELECT MIN(ABS(100-cislo)) 
                        FROM tabulka);

Kód: Vybrať všetko

DELETE FROM `tabulka` WHERE `percento` > 100