View Single Post
  #2 (permalink)  
Old 10-29-2007, 04:40 AM
priyan priyan is offline
D-Web Sr.Programmer
 
Join Date: Mar 2007
Posts: 133
priyan is on a distinguished road
Default Re: To get random number in mysql

Hi Techies,

We can do it in this way also..

-- For getting four digit random number
SELECT FLOOR(1000+ RAND()*8999) FROM DUAL;
__________________
Keep smiling...
Reply With Quote