MySQL select random integer range

You can use this query to generate a random integer between 1 and 100:


SELECT (FLOOR( 1 + RAND( ) *100 ))