1 MYSQL取得某一范围随机数：
关键词：RAND() [产生0~1之间的随机数]
mysql> SELECT RAND( ), RAND( ), RAND( ); +------------------+-----------------+------------------+ | RAND( ) | RAND( ) | RAND( ) | +------------------+-----------------+------------------+ | 0.45464584925645 | 0.1824410643265 | 0.54826780459682 | +------------------+-----------------+------------------+
可根据自己需求 RAND() * i [i值变动].
原文：http://www.cnblogs.com/yazoon/p/5794662.html