How to get 4-digit Random number
The following code will generate 4 digit random number.
using this code you can get upto 300 digit random number.
Code:
SET @number:=4;
select cast(FLOOR(concat('1',REPEAT('0',@number-1)) + (RAND() * CONCAT('9',REPEAT('0',@number-1))))as binary); output
4523
3821
9656