RAND
Random decimal number between 0 and 1.
Examples
- RAND() - Random decimal number between 0 and 1.
To generate a random number in a different range, multiply the result — e.g., RAND()*100 for a number between 0 and 100, or INT(RAND()*6)+1 for a random integer from 1 to 6.