Mega Code Archive

 

Categories / MySQL / Function

 

Get some random numbers in the range 1-100

mysql> mysql> SELECT CEILING(RAND() * 100), CEILING(RAND() * 100); +-----------------------+-----------------------+ | CEILING(RAND() * 100) | CEILING(RAND() * 100) | +-----------------------+-----------------------+ |                    43 |                    84 | +-----------------------+-----------------------+ 1 row in set (0.00 sec) mysql>