View Single Post
  #8 (permalink)  
Old 11-05-2007, 11:34 PM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: To get random number in mysql

To get 4 digit random number

Code:
SET @number:=4;
set @string:='';
SET @sql:=REPLACE('SET @t:=BENCHMARK(X,@string:=concat(@string,char(FLOOR(48+RAND()*9))));','X',@number);
prepare stm1 from @sql;
execute stm1 ;
select @string;
OUTPUT
Code:
1484
4532
5234
__________________
-Murali..
Reply With Quote