mysql> select rand();+--------------------+| rand()             |+--------------------+| 0.9913473352709294 |+--------------------+1 row in set (0.00 sec)mysql> select rand()*100;+-------------------+| rand()*100        |+-------------------+| 57.10881106286199 |+-------------------+1 row in set (0.01 sec)