It would make it much more difficult to make it to have a range of values (tolerance) as in sql terms that would be individual between (9999 and 10001) for example

Though I certainly see the appeal of doing that.

Code:
MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user where (truncate(metric1,0) between 9999 and 10001) or (truncate(metric1,0) between 99999 and 100001) group by cpid order by mycount desc limit 0,10;
+----------------------------------+-------------+---------+
| cpid                             | nick        | mycount |
+----------------------------------+-------------+---------+
| 0dd9749ec16c8900f065d871290156bc | BAR         |       8 |
| 2286c5351f0f2d2f5d7fee45967f22b8 | Baryna.ch   |       7 |
| 61c4eaaca6667bc9dda3412188c5f173 | x3mEn       |       6 |
| e33013c782482e80caf0c65b476a2d87 | JayPi       |       5 |
| a848091602d6dade8ee661252d106d2d | rilian      |       4 |
| 89e772f65716bba7c962b4a13d14e350 | AMDave      |       4 |
| d5f358d1a7913ab61d7ea87c85aafbfd | Buster Gunn |       4 |
| 8f15950e07e24a5c0c73016a77c952e9 | Nflight     |       3 |
| 3a045e428e45f087f7cc832bdb4791ff | RAD-Poland  |       3 |
| 2e8203c09bffa7dd415284af2124eb53 | skivelitis  |       2 |
+----------------------------------+-------------+---------+
10 rows in set (9.725 sec)
but, saying that - it would only run once per day.